Thu 9 Feb 2017 4:21AM
updating to stretch: plan
![PP](/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBWDA9IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--08d9c0c0c40ebf75e482da72b97b8f697df4a57a/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdDRG9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RkhKbGMybDZaVjkwYjE5c2FXMXBkRnNIYVFHQWFRR0FPZ3B6WVhabGNuc0hPZ3h4ZFdGc2FYUjVhVlU2Q25OMGNtbHdWQT09IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--ab08e3537826c078bb35a6ee1bf34556480c5182/IMG_20200919_132719.jpg)
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
![PP](/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBWDA9IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--08d9c0c0c40ebf75e482da72b97b8f697df4a57a/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdDRG9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RkhKbGMybDZaVjkwYjE5c2FXMXBkRnNIYVFHQWFRR0FPZ3B6WVhabGNuc0hPZ3h4ZFdGc2FYUjVhVlU2Q25OMGNtbHdWQT09IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--ab08e3537826c078bb35a6ee1bf34556480c5182/IMG_20200919_132719.jpg)
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
![PP](/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBWDA9IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--08d9c0c0c40ebf75e482da72b97b8f697df4a57a/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdDRG9MWm05eWJXRjBTU0lJYW5CbkJqb0dSVlE2RkhKbGMybDZaVjkwYjE5c2FXMXBkRnNIYVFHQWFRR0FPZ3B6WVhabGNuc0hPZ3h4ZFdGc2FYUjVhVlU2Q25OMGNtbHdWQT09IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--ab08e3537826c078bb35a6ee1bf34556480c5182/IMG_20200919_132719.jpg)
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).