How to upgrade PostgreSQL from version 9.6 to version 10.1 without losing data? [closed]
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 10.1 database: initdb /usr/local/var/postgres10.1 -E utf8 run pg_upgrade (note: change bin version if you’re upgrading from something other than below): pg_upgrade -v \ -d /usr/local/var/postgres \ -D /usr/local/var/postgres10.1 \ -b … Read more