PostgreSQL 9.2 upgrade steps

gistfile1.txt

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. brew update
3. brew upgrade postgresql
4. initdb /usr/local/var/postgres/9.2 -E utf8 -U postgres
5. pg_upgrade -u postgres -b /usr/local/Cellar/postgresql/9.1.5/bin -B /usr/local/Cellar/postgresql/9.2.0/bin -d /usr/local/var/postgres/9.1 -D /usr/local/var/postgres/9.2
6. cp /usr/local/Cellar/postgresql/9.2.1/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/
7. pg_ctl -D /usr/local/var/postgres/9.2 -l /usr/local/var/postgres/server.log start

If you're using ruby, also:

gem pristine pg