PostgreSQL Installation on Mac: Difference between revisions
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
==Start at Login== | ==Start at Login== | ||
To have launchd start postgresql now and restart at login: | To have <code>[[Mac launchd|launchd]]</code> start <code>postgresql</code> now and restart at login: | ||
brew services start postgresql | brew services start postgresql | ||
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