Skip to content

Instantly share code, notes, and snippets.

@beanieboi

beanieboi/gist:2702092

Created May 15, 2012 14:15
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save beanieboi/2702092 to your computer and use it in GitHub Desktop.
Save beanieboi/2702092 to your computer and use it in GitHub Desktop.
Download ZIP
Upgrade to Postgres 9.2 beta 1 on Ubuntu 12.04
Raw
gistfile1.txt
# Install Postgres 9.2 from https://launchpad.net/~pitti/+archive/postgresql
# drop the cluster which gets created during the setup
pg_dropcluster --stop 9.2 main
# create a backup of your current cluster
rsync -a /var/lib/postgresql/9.1 /var/lib/postgresql/9.1.backup
# upgrade the the old 9.1 cluster
pg_upgradecluster 9.1 main /var/lib/postgresql/9.2
# if everything is perfect, drop the old cluster
pg_dropcluster 9.1 main
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment