Skip to content

Instantly share code, notes, and snippets.

@aelkz

aelkz/upgrade-postgres-9.4-to-9.5.md

Forked from Komzpa/upgrade-postgres-9.4-to-9.5-to-9.6-to-10.md
Created September 23, 2017 17:01
Show Gist options
  • Save aelkz/2add7b02f874a76035f0d9fc4177d518 to your computer and use it in GitHub Desktop.
Save aelkz/2add7b02f874a76035f0d9fc4177d518 to your computer and use it in GitHub Desktop.
Download ZIP
Upgrading PostgreSQL from 9.4 to 9.5 when upgrading Ubuntu 14.10 to 16.04
Raw
upgrade-postgres-9.4-to-9.5.md

TL;DR

sudo pg_dropcluster 9.5 main --stop
sudo service postgresql stop
sudo pg_upgradecluster -m upgrade -k 9.4 main
sudo su postgres -c "/usr/lib/postgresql/9.5/bin/vacuumdb --all --analyze-in-stages"
sudo pg_dropcluster 9.4 main
@aelkz
Copy link
Author

aelkz commented Sep 23, 2017

https://gist.github.com/Komzpa/994d5aaf340067ccec0e

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