PostgreSQL 9.6.5 to 10.2 upgrade steps

gistfile1.txt

Steps to install and run PostgreSQL 9.6.5 using Homebrew (Mac OS X)

1. launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
2. mv /usr/local/var/postgres /usr/local/var/postgres96
3. brew update
4. brew upgrade postgresql
5. initdb /usr/local/var/postgres -E utf8
6. pg_upgrade -b /usr/local/Cellar/postgresql/9.6.5/bin -B /usr/local/Cellar/postgresql/10.2/bin -d /usr/local/var/postgres96 -D /usr/local/var/postgres
7. cp /usr/local/Cellar/postgresql/10.2/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/
8. pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

If you're using ruby, also:

gem pristine pg