Auto upgrade non-HA PostgreSQL to PG17
Postgres 16 is going to become our minimum supported version in GitLab 18. We should turn on the auto-upgrade for single node installs in `18.11`.
- [x] Swap `attempt_auto_pg_upgrade?` to true in https://gitlab.com/gitlab-org/omnibus-gitlab/-/blob/master/files/gitlab-ctl-commands/upgrade.rb
- [x] Swap `ATTEMPT_AUTO_PG_UPGRADE` to true in https://gitlab.com/gitlab-org/omnibus-gitlab/-/blob/master/docker/assets/wrapper
- [x] Ensure the pg-upgrade upgrade command is working as expected
- [x] Update the documentation to reflect these changes.
- [ ] Notify `@gitlab-org/delivery` once this issue completes
- [x] Notify users via a ~"release post item"
The last time we did this was https://gitlab.com/gitlab-org/omnibus-gitlab/-/work_items/8504+ and https://gitlab.com/gitlab-org/omnibus-gitlab/-/merge_requests/7490+
issue