Update postgres

Aus Laemmi´s Wiki
Version vom 21. Dezember 2018, 12:27 Uhr von Laemmi (Diskussion | Beiträge) (→‎Init new DB)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Zur Navigation springen Zur Suche springen

Check

brew info postgresql
psql --version

Backup

mv /usr/local/var/postgres/ /usr/local/var/postgres.x.x.backup/

Init new DB

initdb /usr/local/var/postgres/
/usr/local/opt/postgresql/bin/initdb --locale=de_DE.UTF-8 -D /usr/local/var/postgres -E utf8

Stop

launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
rm ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
pg_ctl -D /usr/local/var/postgres stop -m fast
pg_ctl -D /usr/local/var/postgres.x.x.backup stop -m fast

Upgrade

pg_upgrade -b /usr/local/Cellar/postgresql/x.old/bin/ -B /usr/local/Cellar/postgresql/x.new/bin/ -d /usr/local/var/postgres.x.x.backup/ -D /usr/local/var/postgres

Restart

ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist