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

Related

• PostgreSQL versions/releases

See also

• PostgreSQL: pg_dump, pg_restore, pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB, Adminer, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs, postgresql.conf, pg_hba.conf, $HOME/.pg_service.conf, Create database (PostgreSQL), Create user, createdb, GRANT, pg_stat, PostgreSQL VACUUM, EXPLAIN, pg stat activity, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL), EXPLAIN ANALYZE, Bitmap scan, EXPLAIN VERBOSE, EXPLAIN VERBOSE (PostgresSQL), WAL, ALTER USER, CREATE ROLE, CREATE USER, \du, show users, \l, The Statistics Collector, pganalyze, cron.schedule, Master, pg_tables, PostgreSQL replication, CREATE, SET, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users