|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. pg_ctl -D /usr/local/var/postgres stop -s -m fast|
|2. mv /usr/local/var/postgres /usr/local/var/postgres91|
|3. curl https://raw.github.com/fragility/homebrew/737af01178590950749cf5e841f2d086c57c5a80/Library/Formula/postgresql.rb > /usr/local/Library/Formula/postgresql.rb|
|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. pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start|
Using launchctl to run PostgreSQL, so I suspect the postgres server will relaunch within a few seconds of executing line 1.
Remember it is always good to do a pg_dumpall before you start!
Also, I had a problem with pg_upgrade, it did not like that I had different lc_collate on each database setup, and did not run. I suspect that was due to the "-E utf8" option to initdb, which I may not have had before (but want now).
So I restored from the dump I took. :-)