brew install postgresql@16

brew install postgresql@16 && brew services start postgresql@16 && brew services info 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

• PostgreSQL versions/releases

See also

• PostgreSQL: psql, .psqlrc, .pgpass, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql -c, \?, \connect, \conninfo, --version, --help, PL/pgSQL
• brew install postgresql, PostgreSQL versions, psql, brew install libpq, Database operations