Skip to content

Instantly share code, notes, and snippets.

@HerrSpace

HerrSpace/gist:58bace2634ab972b7ed8bd76c6143ddf

Created July 26, 2019 13:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save HerrSpace/58bace2634ab972b7ed8bd76c6143ddf to your computer and use it in GitHub Desktop.
Save HerrSpace/58bace2634ab972b7ed8bd76c6143ddf to your computer and use it in GitHub Desktop.
Download ZIP
how to pg clusterupgrade
Raw
gistfile1.txt
- prepare a new puppet branch with the updated version in the postgresql globals
- add the new pkgs to your repo and install them on the server
- systemctl stop postgresql@<old-version>
- systemctl stop postgresql@<new-version>
- pg_dropcluster <new version> main --stop
- try pg_upgradecluster <old version> main -j <cores> --link --method=upgrade
- if that fails try pg_upgradecluster <old version> main
- pg_dropcluster <old version> main
- run puppet with your new branch
- uninstall the old pg version
- maybe clean failed services or whatever
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment