postgresql@15

Deprecation date: 2027-11-11

Disable date: 2028-11-11

Install command:
brew install postgresql@15

Object-relational database system

https://www.postgresql.org/

License: PostgreSQL

Development: Pull requests

Formula JSON API: /api/formula/postgresql@15.json

Formula code: postgresql@15.rb on GitHub

Bottle (binary package) installation support provided for:

macOS on
Apple Silicon
golden gate
tahoe
sequoia
sonoma
macOS on
Intel
sonoma
Linux ARM64
x86_64

Current versions:

stable 15.19

Other versions:

postgresql@18 18.6 Object-relational database system
postgresql@17 17.11 Object-relational database system
postgresql@16 16.15 Object-relational database system
postgresql@14 14.24 Object-relational database system
postgresql@13 13.23 Object-relational database system
postgresql@12 12.22 Object-relational database system

Keg-only because this is an alternate version of another formula.

Depends on:

icu4c@78 78.3 C/C++ and Java libraries for Unicode and globalization
krb5 1.22.2 Network authentication protocol
lz4 1.10.0 Extremely Fast Compression algorithm
openssl@3 3.6.4 Cryptography and SSL/TLS Toolkit
readline 8.3.6 Library for command-line editing
zstd 1.5.7 Zstandard is a real-time compression algorithm
gettext 1.0 GNU internationalization (i18n) and localization (l10n) library

Depends on when building from source:

gettext 1.0 GNU internationalization (i18n) and localization (l10n) library
pkgconf 3.0.7 Package compiler and linker metadata toolkit

Uses from macOS: libxml2, libxslt, openldap, perl

Binaries: clusterdb, createdb, createuser, dropdb, dropuser, ecpg, initdb, oid2name, pg_amcheck, pg_archivecleanup, pg_basebackup, pg_checksums, pg_config, pg_controldata, pg_ctl, pg_dump, pg_dumpall, pg_isready, pg_receivewal, pg_recvlogical, pg_resetwal, pg_restore, pg_rewind, pg_test_fsync, pg_test_timing, pg_upgrade, pg_verifybackup, pg_waldump, pgbench, postgres, postmaster, psql, reindexdb, vacuumdb, vacuumlo

Service:

Start now and at login: brew services start postgresql@15
Run directly: $HOMEBREW_PREFIX/opt/postgresql@15/bin/postgres -D $HOMEBREW_PREFIX/var/postgresql@15
This formula has created a default database cluster with:
    initdb --locale=en_US.UTF-8 -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@15

Analytics:

30 days90 days365 days
Installs3,07414,43992,046
Installs (--HEAD)722165
Installs on Request3,06814,40591,861
Installs on Request (--HEAD)722165
Build Errors5