README.md

Upgrading data from Postgres 9.4 to Postgres 9.5

Solving the The data directory was initialized by PostgreSQL version 9.4, which is not compatible with this version 9.5.0. panic ;) This is mainly for Postgres installed via Homebrew, but you can adapt it to your system pretty easily.

upgrade_postgres.zsh

launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

cd /usr/local/var

tar -vcf postgres-data-9.4.tar postgres

mv postgres postgres.old

initdb postgres -E utf8

pg_upgrade --old-datadir postgres.old \
    --new-datadir postgres \
    --old-bindir /usr/local/Cellar/postgresql/9.4.5_2/bin/ \
    --new-bindir /usr/local/Cellar/postgresql/9.5.0/bin
    
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
    
./analyze_new_cluster.sh