gistfile1.txt

Steps to upgrade from PostgreSQL 9.1.5 to 9.2.4 using Homebrew (Mac OS X)
if you're using `launchd` to manage PostgreSQL
and your superuser is named `postgres`.

1. pg_dumpall -U postgres > postgres-9.1.5-dumpall
2. launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
3. mv /usr/local/var/postgres /usr/local/var/postgres91
4. brew upgrade postgresql
5. initdb /usr/local/var/postgres -E utf8 -U postgres
6. launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
7. psql -U postgres < ~/postgres-9.1.5-dumpall

YMMV