Latest revision as of 21:38, 6 October 2023

Internal

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

See:

PGDATA

brew upgrade postgresql

To have launchd start postgresql now and restart at login:

brew services start postgresql@14

For more details, see:

brew services

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

Explore equivalency with:

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

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

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

@@ Line 7: / Line 7: @@
 ==Initial Installation==
+<syntaxhighlight lang='bash'>
+brew install postgresql
+</syntaxhighlight>
+===Configure Environment===
+The installation output will contain the value to used for <code>-D</code> flag (the database directory).
- brew install postgresql
+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>.
+Add to <code>.bashrc</code>:
+<syntaxhighlight lang='bash'>
+export PGDATA=/opt/brew/var/postgresql@14
+</syntaxhighlight>
+See: {{Internal|PostgreSQL_Concepts#PGDATA|PGDATA}}
 ==Update Already Installed Package==
@@ Line 19: / Line 30: @@
 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@14
 </syntaxhighlight>