Skip to content

Instantly share code, notes, and snippets.

@nileshk

nileshk/upgrade_postgres.sh

Last active November 22, 2018 15:02
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nileshk/c8962a32fbc50d5aa051c7293bae12e3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nileshk/c8962a32fbc50d5aa051c7293bae12e3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
upgrade_postgres.sh
sudo pg_dropcluster 10 main --stop
sudo pg_upgradecluster 9.6 main
sudo pg_dropcluster 9.6 main
sudo apt purge postgresql-9.6 postgresql-client-9.6 postgresql-contrib-9.6
@nileshk
Copy link
Author

nileshk commented Nov 22, 2018 •
edited
Loading

If upgrading from Postgres 9.5 (e.g. Ubuntu 16.04 -> 18.04):

sudo pg_dropcluster 10 main --stop
sudo pg_upgradecluster 9.5 main
sudo pg_dropcluster 9.5 main
sudo apt purge postgresql-9.5 postgresql-client-9.5 postgresql-contrib-9.5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment