Hi , we wanted to upgrade gitlab ce to 15.05 and documentation says minimum 12.10 postgresql version is required , we currently have pg 12.7 and thought of upgrading pg version before gitlab ce to 15.05 and while doing this it printed below message ,
gitlab-ctl pg-upgrade
Checking for an omnibus managed postgresql: OK
Checking if postgresql[‘version’] is set: OK
Checking if we already upgraded: OK
The latest version 12.7 is already running, nothing to do
@iwalker ,also i came to know if we use omnibus, it will bundle the correct version when you actually upgrade our GitLab version. The notice of minimum pg version is mostly useful for folks using their own Postgres server.
So i have upgraded directly my gitlab-ce test instance from 14.10.5 to 15.0.5 and gradually postgresql also got upgraded to 12.10 version .
you can safely delete, they are not needed (as per the docs I linked. They are leftovers from previous upgrades. You can also delete this file if it exists:
/var/opt/gitlab/postgresql-version.old
Also I’m wondering, why do you have the skip-auto-reconfigure in your /etc/gitlab directory? I would remove this as well, unless you have created it and need it for a reason, since reconfigure will not be ran, and it could also be a potential reason why you have issues.
Maybe the missing VERSION file is because it appeared in later versions.
Since your test instance worked fine from what you said, I’m wondering what is wrong with your production server, whether it is omnibus or source installation. I don’t see how it can have 12.7 when the Gitlab 15.0 releases don’t even have that.
@iwalker -We have omnibus and our gitlab ce test instance was having version 14.10.5 and pg version was 12.7 ,later we upgraded gitlab ce from 14.10.5 to 15.0.5 and in this gitlab upgrade process underlined postgres also got upgraded to 12.10 . Saying that now our prod also stays at 14.10.5 currently and pg version at 12.7 and we are thinking to follow same steps in prod what we followed in test instance.