PostgreSQL Installation on Mac: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 18: Line 18:


To have <code>[[Mac launchd|launchd]]</code> start <code>postgresql</code> now and restart at login:
To have <code>[[Mac launchd|launchd]]</code> start <code>postgresql</code> now and restart at login:
 
<syntaxhighlight lang='bash'>
  brew services start postgresql
brew services start postgresql
</syntaxhighlight>


=To Run without a Service=
=To Run without a Service=

Revision as of 21:02, 6 October 2023

Internal

Overview

Initial Installation

brew install postgresql

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

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