brew install postgresql

brew install postgresql@17 (2024)
brew install postgresql@16 (2023)
brew install postgresql@15
brew install postgresql@14
brew install postgresql@13

brew install postgresql (deprecated)

List of available versions (brew formulae):

brew info --json postgresql | jq -r '.[].versioned_formulae[]'
Warning: Use postgresql@14 instead of deprecated postgresql
postgresql@13
postgresql@12
postgresql@11
postgresql@10
[email protected]
[email protected]
[email protected]

Connect to PostgreSQL

• createdb your-db && psql your-db

Related

• brew install libpq includes psql
• PostgreSQL versions
• PostgreSQL extensions
• make test
• createdb your-db && psql your-db
• Dependencies: krb5
• brew install mariadb

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