Upgrade Postgres 9.1 to 9.2

Upgrade Postgres 9.1 to 9.2

cd /usr/local/var
mkdir postgres9.2
 
# Initialize a the new postgres 9.2 database
initdb /usr/local/var/postgres9.2
 
# Tell postgres we are upgrading the existing postgres database to the new postgres9.2 location
pg_upgrade -d /usr/local/var/postgres/ -D /usr/local/var/postgres9.2 -b /usr/local/Cellar/postgresql/9.1.4/bin/ -B /usr/local/Cellar/postgresql/9.2.1/bin/ -v
 
# Swap the folders
mv postgres postgres9.1.4
mv postgres9.2 postgres
 
# Remove this unnecessary helper file
rm delete_old_cluster.sh
 
# Restart postgres
launchctl unload -w homebrew.mxcl.postgresql.plist
launchctl load -w homebrew.mxcl.postgresql.plist

FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 9.1.4, which is not compatible with this version 9.2.1.