Skip to content

Instantly share code, notes, and snippets.

@adamgibbons

adamgibbons/upgrade-psql

Last active August 29, 2015 14:22
Show Gist options
  • Save adamgibbons/0ff434998a390bdc880e to your computer and use it in GitHub Desktop.
Save adamgibbons/0ff434998a390bdc880e to your computer and use it in GitHub Desktop.
Download ZIP
Upgrade PostgreSQL
Raw
upgrade-psql
`launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist`
`mv /usr/local/var/postgres /usr/local/var/postgres.old`
`initdb -D /usr/local/var/postgres`
`pg_upgrade -b /usr/local/Cellar/postgresql/9.3.5_1/bin -B /usr/local/Cellar/postgresql/9.4.3/bin -d /usr/local/var/postgres.old -D /usr/local/var/postgres`
`./delete_old_cluster.sh`
`rm delete_old_cluster.sh`
`launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment