Skip to content

Instantly share code, notes, and snippets.

@joho
Forked from rafaelss/gist:3700977
Created September 17, 2012 05:40
Show Gist options
  • Save joho/3735740 to your computer and use it in GitHub Desktop.
Save joho/3735740 to your computer and use it in GitHub Desktop.
PostgreSQL 9.2 upgrade steps
Steps to install and run PostgreSQL 9.2 using Homebrew (Mac OS X)
(if you aren't using version 9.1.5, change line 6 with the correct version)
1. launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
2. mv /usr/local/var/postgres /usr/local/var/postgres91
3. brew update
4. brew upgrade postgresql
5. initdb /usr/local/var/postgres -E utf8
6. pg_upgrade -b /usr/local/Cellar/postgresql/9.1.5/bin -B /usr/local/Cellar/postgresql/9.2.0/bin -d /usr/local/var/postgres91 -D /usr/local/var/postgres
7. cp /usr/local/Cellar/postgresql/9.2.0/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/
8. pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
If you're using ruby, also:
gem pristine pg
@JocelynTriplett
Copy link

Thanks so much for this!

@skywalker19
Copy link

Thanks.. also work when upgrading 12 to 14

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