PostgreSQL Installation on Mac

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

Internal

Overview

Initial Installation

brew install postgresql

The installation output will contain the value to used for -D flag (the database directory).

Write it down and set the PGDATA environment variable to that value, so pg_ct commands will work without an explicit -D.

Add to .bashrc:

export PGDATA=/opt/brew/var/postgresql@14

Update Already Installed Package

brew upgrade postgresql

Operate the Database as a Service

Start at Login

To have launchd start postgresql now and restart at login:

brew services start postgresql@14

For more details, see:

brew services

To Run without a Service

/opt/brew/opt/postgresql@14/bin/postgres -D /opt/brew/var/postgresql@14

Explore equivalency with:

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

Status

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

Stop

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