Upgrade steps for homebrew postgresql database

homebrew-postgresql-update-steps.md

Upgrading a PostgreSQL Database

When using homebrew, on OSX

• launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist (old way)
• brew services stop postgresql (new way)
• mv /usr/local/var/postgres /usr/local/var/postgres.old
• initdb /usr/local/var/postgres -E utf8
• pg_upgrade -b /usr/local/Cellar/postgresql/9.3.5_1/bin -B /usr/local/Cellar/postgresql/9.4.0/bin -d /usr/local/var/postgres.old -D /usr/local/var/postgres
• ./delete_old_cluster.sh (automatically generated in current directory)
• rm delete_old_cluster.sh
• launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist (old way)
• brew services start postgresql (new way)

Skip first and last step of course if you don't autorun postgres

You can use brew services stop|start postgresql if you do autorun posgresql.

@wobh updated to reflect that, thanks!