# Install via homebrew
brew install postgresql@9.6
# Verify version information
brew info postgresql@9.6
# Verify service has not started
brew services list
# Ensure verify is linked with
brew link postgresql@9.6 --overwrite --force
# Add version to PATH
export PATH="/usr/local/opt/postgresql@9.6/bin:$PATH"
# Verify version
postgres --version
# Load 
ln -sfv  /usr/local/Cellar/postgresql@9.6/9.6.17/homebrew.mxcl.postgresql@9.6.plist ~/Library/LaunchAgents/
# launch the service
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql@9.6.plist
# Verify service has started
brew services list
# Verify database works with username and no password needed
psql postgres -U <user_name>
# Usefull materials
https://www.postgresql.org/download/macosx/
https://www.codementor.io/@engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb
https://itnext.io/configure-postgresql-on-your-mac-from-scratch-197f8eb4048a
https://wiki.postgresql.org/wiki/PostgreSQL_Clients#SQL_Workbench.2FJ
https://wiki.postgresql.org/wiki/PostgreSQL_Clients#pgManage
https://www.robinwieruch.de/postgres-sql-macos-setup
https://www.moncefbelyamani.com/how-to-install-postgresql-on-a-mac-with-homebrew-and-lunchy/
https://www.codementor.io/@engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb
https://gist.github.com/ibraheem4/ce5ccd3e4d7a65589ce84f2a3b7c23a3