Skip to content

Instantly share code, notes, and snippets.

@cloud8421

cloud8421/postgres_upgrade

Forked from EdwardTippett/postgres_upgrade
Last active December 23, 2015 17:19
Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save cloud8421/6667898 to your computer and use it in GitHub Desktop.
Save cloud8421/6667898 to your computer and use it in GitHub Desktop.
Download ZIP
Osx upgrade postgres from 9.2.4 to 9.3
Raw
postgres_upgrade
Steps to install and run PostgreSQL 9.3 using Homebrew (Mac OS X)
(if you aren't using version 9.2.4, change to the correct version)
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
mv /usr/local/var/postgres /usr/local/var/postgres92
brew upgrade postgresql
initdb /usr/local/var/postgres -E utf8
pg_upgrade -b /usr/local/Cellar/postgresql/9.2.4/bin -B /usr/local/Cellar/postgresql/9.3.0/bin -d /usr/local/var/postgres92 -D /usr/local/var/postgres
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