Postgres: Getting started

Install

Postgres Server

brew install postgres

Postgres Utilities

• pgAdmin
• PSequel, a PostgreSQL GUI Tool for macOS

Documentation

• Upgrade
• Migrate existing data from a previous minor version (9.0-9.5) of PostgreSQL

Working with

You will need your previous PostgreSQL installation from brew to perform `pg_upgrade`.
Do not run `brew cleanup postgresql` until you have performed the migration.

• To have launchd start postgresql now and restart at login:

brew services start postgresql

• If you don’t want/need a background service you can just run:

 pg_ctl -D /usr/local/var/postgres startpc_c