PostgreSQL upgrade
Standing on the shoulders of the other poor creatures trodding through this muck, I was able to follow these steps to get back up and running after an upgrade to Yosemite:
Assuming you've used home-brew to install and upgrade Postgres, you can perform the following steps.
- Stop current Postgres server:
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
- Initialize a new 9.4 database:
initdb /usr/local/var/postgres9.4 -E utf8
- Install postgres 9.3 (as it was no longer present on my machine):
brew install homebrew/versions/postgresql93
- Add directories removed during Yosemite upgrade:
mkdir -p /usr/local/var/postgres/{pg_tblspc,pg_twophase,pg_stat_tmp}/touch /usr/local/var/postgres/{pg_tblspc,pg_twophase,pg_stat_tmp}/.keep
- run
pg_upgrade
:pg_upgrade -v -d /usr/local/var/postgres -D /usr/local/var/postgres9.4 -b /usr/local/Cellar/postgresql93/9.3.5/bin/ -B /usr/local/Cellar/postgresql/9.4.0/bin/
- Move new data into place:
cd /usr/local/var mv postgres postgres9.3 mv postgres9.4 postgres
- Restart Postgres:
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
- Check
/usr/local/var/postgres/server.log
for details and to make sure the new server started properly. - Finally, re-install related libraries?
pip install --upgrade psycopg2 gem uninstall pg gem install pg
Comments
Post a Comment