Skip to content

Instantly share code, notes, and snippets.

@v-thomp4
Created May 31, 2017 04:28
Show Gist options
  • Save v-thomp4/82e202654cd0db9df214c6dff9c226f3 to your computer and use it in GitHub Desktop.
Save v-thomp4/82e202654cd0db9df214c6dff9c226f3 to your computer and use it in GitHub Desktop.
upgrade postgres centos
Edit your pg_hba.conf and set connections on local to trust for the duration of the upgrade.
/usr/pgsql-9.5/bin/pg_upgrade --old-bindir=/usr/pgsql-9.4/bin/ --new-bindir=/usr/pgsql-9.5/bin/ --old-datadir=/var/lib/pgsql/9.4/data/ --new-datadir=/var/lib/pgsql/9.5/data/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment