hartct

1. launchctl unload -w ~/Library/LaunchAgents/org.postgresql.postgres.plist
2. mv /usr/local/var/postgres9 /usr/local/var/postgres90
3. curl https://raw.github.com/fragility/homebrew/737af01178590950749cf5e841f2d086c57c5a80/Library/Formula/postgresql.rb > /usr/local/Library/Formula/postgresql.rb
4. brew install postgresql # if this doesn't work, homebrew may have an existing installation. you can try a brew upgrade postgresql but some of the instructions that follow may need to change...
4b. at this point, check to make sure that the postgres binaries are linked and in the path correctly. try doing psql -V and confirm it shows version 9.2. If it doesn't, adjust your path so /usr/local/Cellar/postgresql/9.2.0/bin/ is in front of the offending locations with postgres binaries in them or fight with brew link to fix it. 
5. initdb /usr/local/var/postgres -E utf8
6. Edit ~/Library/LaunchAgents/org.postgresql.postgres.plist file to point to your new locations, probably looking like this:

<?xml version="1.0" encodi