Edited at

homebrewでのpostgresql9.4アップグレードメモ

More than 3 years have passed since last update.

9.3.0から9.4.0へ

psql --version

=> psql (PostgreSQL) 9.3.0

brew update

brew upgrade postgresql
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
mv /usr/local/var/postgres /usr/local/var/postgres93
initdb /usr/local/var/postgres -E utf8
pg_upgrade \
-b /usr/local/Cellar/postgresql/9.3.0/bin \
-B /usr/local/Cellar/postgresql/9.4.0/bin \
-d /usr/local/var/postgres93 \
-D /usr/local/var/postgres
cp /usr/local/Cellar/postgresql/9.4.0/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/
launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

psql --version

=> psql (PostgreSQL) 9.4.0