PostgreSQL Installation on Mac

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

Internal

Overview

Initial Installation

brew install postgresql

Update Already Installed Package

brew upgrade postgresql

Start at Login

To have launchd start postgresql now and restart at login:

 brew services start postgresql

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