PostgreSQL Installation on Mac: Difference between revisions
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
brew install postgresql | brew install postgresql | ||
</syntaxhighlight> | </syntaxhighlight> | ||
The installation output will contain the value to used for <code>-D</code> flag (the database directory). | |||
Write it down and set the <code>PGDATA</code> environment variable to that value, so <code>pg_ct</code> commands will work without an explicit <code>-D</code>. | |||
==Update Already Installed Package== | ==Update Already Installed Package== | ||
Revision as of 21:33, 6 October 2023
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.
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:
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