Difference between revisions of "Brew install postgresql@16"

From wikieduonline
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 10: Line 10:
 
  postgresql@16 is [[keg-only]], which means it was not symlinked into /Users/user/brew,
 
  postgresql@16 is [[keg-only]], which means it was not symlinked into /Users/user/brew,
 
  because this is an alternate version of another formula.
 
  because this is an alternate version of another formula.
−
<pre>
+
−
If you need to have postgresql@16 first in your PATH, run:
+
If you need to have postgresql@16 first in your PATH, run:
−
  echo 'export PATH="/Users/user/brew/opt/postgresql@16/bin:$PATH"' >> ~/.zshrc
+
  echo 'export PATH="/Users/user/brew/opt/postgresql@16/bin:$PATH"' >> ~/.zshrc
−
 
+
−
For compilers to find postgresql@16 you may need to set:
+
For compilers to find postgresql@16 you may need to set:
 
   export LDFLAGS="-L/Users/user/brew/opt/postgresql@16/lib"
 
   export LDFLAGS="-L/Users/user/brew/opt/postgresql@16/lib"
 
   export CPPFLAGS="-I/Users/user/brew/opt/postgresql@16/include"
 
   export CPPFLAGS="-I/Users/user/brew/opt/postgresql@16/include"
−
 
+
−
For pkg-config to find postgresql@16 you may need to set:
+
For pkg-config to find postgresql@16 you may need to set:
 
   export PKG_CONFIG_PATH="/Users/user/brew/opt/postgresql@16/lib/pkgconfig"
 
   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
  
−
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
 
−
</pre>
 
  
 +
[[createdb]] mydemo && [[psql]] mydemo
  
 
== Related ==
 
== Related ==

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]

Retrieved from "https://www.wikieduonline.com/index.php?title=Brew_install_postgresql@16&oldid=287481"

Advertising: