Thu 9 Feb 2017 4:21AM
updating to stretch: plan
Pirate Praveen
Public
Seen by 469
I think we should update to stretch as we are in freeze.
- This will reduce extra backporting to jessie work
- We will have more testing to fix issues before release
Pirate Praveen Wed 16 Aug 2017 10:25AM
steps inspired from https://medium.com/@tk512/upgrading-postgresql-from-9-3-to-9-4-on-ubuntu-14-04-lts-2b4ddcd26535
systemctl stop gitlab
systemctl stop postgresql
cp -r /var/lib/postgresql/9.4 /var/lib/postgresql/9.4-backup
apt-get -t jessie-backports install postgresql-contrib
pg_lsclusters # should show both 9.4 and 9.6
pg_dropcluster --stop 9.6 main
systemctl start postgresql
pg_upgradecluster 9.4 main
pg_lsclusters # should show 9.4 offline and 9.6 online
systemctl start gitlab # verify gitlab is working
pg_dropcluster 9.4 main
pg_lsclusters # should show 9.6 only
Pirate Praveen Wed 16 Aug 2017 11:01AM
We now have postgresql 9.6. Next is updating gitlab to stretch and then dist-upgrade to stretch.
Pirate Praveen · Wed 16 Aug 2017 10:15AM
I'll be updating postgresql-contrib to 9.6 from 9.4 to make the update to stretch smooth. I'll take gitlab down for a few minutes to take backup of /var/lib/postgresql/9.4 (just in case we need to revert).