We will go through the process of installing PostgeSQL under Mac OS X with HomeBrew.
- Install PostgreSQL
$ brew install postgresql
If builds of PostgreSQL 9 are failing and you have version 8.x installed,
you may need to remove the previous version first. See:
To migrate existing data from a previous major version (pre-9.0) of PostgreSQL, see:
To migrate existing data from a previous minor version (9.0-9.5) of PostgreSQL, see:
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
Or, if you don’t want/need a background service you can just run:
pg_ctl -D /usr/local/var/postgres start