Difference between revisions of "Brew install postgresql@16"

From wikieduonline
Jump to navigation Jump to search
(Created page with "{{lc}} brew install postgresql@16 {{PG}}")
 
 
(5 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
  [[brew install]] postgresql@16
 
  [[brew install]] postgresql@16
  
 +
==> Caveats
 +
This formula has created a default database cluster with:
 +
  [[initdb]] --locale=C -E UTF-8 /Users/user/brew/var/postgresql@16
 +
For more details, read:
 +
  https://www.postgresql.org/docs/16/app-initdb.html
 +
 +
postgresql@16 is [[keg-only]], which means it was not symlinked into /Users/user/brew,
 +
because this is an alternate version of another formula.
 +
 +
If you need to have postgresql@16 first in your PATH, run:
 +
  echo 'export PATH="/Users/user/brew/opt/postgresql@16/bin:$PATH"' >> ~/.zshrc
 +
 +
For compilers to find postgresql@16 you may need to set:
 +
  export LDFLAGS="-L/Users/user/brew/opt/postgresql@16/lib"
 +
  export CPPFLAGS="-I/Users/user/brew/opt/postgresql@16/include"
 +
 +
For pkg-config to find postgresql@16 you may need to set:
 +
  export PKG_CONFIG_PATH="/Users/user/brew/opt/postgresql@16/lib/pkgconfig"
 +
 +
To start postgresql@16 now and restart at login:
 +
  [[brew services start postgresql@16]]
 +
Or, if you don't want/need a background service you can just run:
 +
  LC_ALL="C" /Users/user/brew/opt/postgresql@16/bin/postgres -D /Users/user/brew/var/postgresql@16
 +
==> Summary
 +
🍺  /Users/user/brew/Cellar/postgresql@16/16.1_1: 3,796 files, 67.4MB, built in 1 minute 18 seconds
  
  
 +
[[createdb]] mydemo && [[psql]] mydemo
  
{{PG}}
+
== Related ==
 +
* [[PostgreSQL versions/releases]]
 +
 
 +
== See also ==
 +
* {{PG}}

Latest revision as of 08:23, 9 January 2024

brew install postgresql@16
==> Caveats
This formula has created a default database cluster with:
  initdb --locale=C -E UTF-8 /Users/user/brew/var/postgresql@16
For more details, read:
  https://www.postgresql.org/docs/16/app-initdb.html

postgresql@16 is keg-only, which means it was not symlinked into /Users/user/brew,
because this is an alternate version of another formula.

If you need to have postgresql@16 first in your PATH, run:
  echo 'export PATH="/Users/user/brew/opt/postgresql@16/bin:$PATH"' >> ~/.zshrc

For compilers to find postgresql@16 you may need to set:
 export LDFLAGS="-L/Users/user/brew/opt/postgresql@16/lib"
 export CPPFLAGS="-I/Users/user/brew/opt/postgresql@16/include"

For pkg-config to find postgresql@16 you may need to set:
 export PKG_CONFIG_PATH="/Users/user/brew/opt/postgresql@16/lib/pkgconfig"

To start postgresql@16 now and restart at login:
 brew services start postgresql@16
Or, if you don't want/need a background service you can just run:
  LC_ALL="C" /Users/user/brew/opt/postgresql@16/bin/postgres -D /Users/user/brew/var/postgresql@16
==> Summary
🍺  /Users/user/brew/Cellar/postgresql@16/16.1_1: 3,796 files, 67.4MB, built in 1 minute 18 seconds


createdb mydemo && psql mydemo

Related[edit]

See also[edit]

Advertising: