Skip to content

Instantly share code, notes, and snippets.

@matthewlehner

matthewlehner/homebrew-postgres-9.6-upgrade.sh

Created November 24, 2016 21:44
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save matthewlehner/6994aa7cf55260df11d046443eed0d8d to your computer and use it in GitHub Desktop.
Save matthewlehner/6994aa7cf55260df11d046443eed0d8d to your computer and use it in GitHub Desktop.
Download ZIP
Upgrades Homebrew Postgres installation from 9.5 to 9.6
Raw
homebrew-postgres-9.6-upgrade.sh
brew services stop postgresql
initdb /usr/local/var/postgres9.6 -E utf8
pg_upgrade -d /usr/local/var/postgres -D /usr/local/var/postgres9.6 -b /usr/local/Cellar/postgresql/9.5.5/bin -B /usr/local/Cellar/postgresql/9.6.1/bin -v
mv /usr/local/var/postgres /usr/local/var/postgres9.5
mv /usr/local/var/postgres9.6 /usr/local/var/postgres
brew services start postgresql
@matthewlehner
Copy link
Author

If it stops working after crash: https://coderwall.com/p/zf-fww/postgres-on-osx-with-homebrew-not-running-after-osx-crash

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