postgres_upgrade

Steps to install and run PostgreSQL 9.3 using Homebrew (Mac OS X)
(if you aren't using version 9.2.4, change to the correct version)

  launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
  mv /usr/local/var/postgres /usr/local/var/postgres92
  brew upgrade postgresql
  initdb /usr/local/var/postgres -E utf8
  pg_upgrade -b /usr/local/Cellar/postgresql/9.2.4/bin -B /usr/local/Cellar/postgresql/9.3.0/bin -d /usr/local/var/postgres91 -D /usr/local/var/postgres
  launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist