postgresql@18
Deprecation date: 2030-11-14
Disable date: 2031-11-14
brew install postgresql@18Also known as: postgres, postgresql
Object-relational database system
License: PostgreSQL
Development: Pull requests
Formula JSON API: /api/formula/postgresql@18.json
Formula code: postgresql@18.rb on GitHub
Bottle (binary package) installation support provided for:
| macOS on Apple Silicon |
golden gate | ✅ |
|---|---|---|
| tahoe | ✅ | |
| sequoia | ✅ | |
| Linux | ARM64 | ✅ |
| x86_64 | ✅ |
Current versions:
| stable | ✅ | 18.7 |
Other versions:
| postgresql@17 | 17.12 | Object-relational database system |
| postgresql@16 | 16.16 | Object-relational database system |
| postgresql@15 | 15.20 | Object-relational database system |
| postgresql@14 | 14.25 | 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@79 | 79.1 | C/C++ and Java libraries for Unicode and globalization |
| krb5 | 1.22.3 | Network authentication protocol |
| lz4 | 1.11.1 | Extremely Fast Compression algorithm |
| openssl@4 | 4.1.0 | 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:
| docbook | 5.2.1 | Standard XML representation system for technical documents |
| docbook-xsl | 1.79.2 | XML vocabulary to create presentation-neutral documents |
| gettext | 1.0 | GNU internationalization (i18n) and localization (l10n) library |
| pkgconf | 3.0.10 | Package compiler and linker metadata toolkit |
Uses from macOS: bison (build), flex (build), curl, libxml2, libxslt, openldap, perl
Binaries:
clusterdb,
createdb,
createuser,
dropdb,
dropuser,
ecpg,
initdb,
oid2name,
pg_amcheck,
pg_archivecleanup,
pg_basebackup,
pg_checksums,
pg_combinebackup,
pg_config,
pg_controldata,
pg_createsubscriber,
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,
pg_walsummary,
pgbench,
postgres,
psql,
reindexdb,
vacuumdb,
vacuumlo
Service:
| Start now and at login: | brew services start postgresql@18 |
| Run directly: | $HOMEBREW_PREFIX/opt/postgresql@18/bin/postgres -D $HOMEBREW_PREFIX/var/postgresql@18 |
| This formula has created a default database cluster with: initdb --locale=en_US.UTF-8 -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@18 When uninstalling, some dead symlinks are left behind so you may want to run: brew cleanup --prune-prefix If the service fails to start with a "postmaster.pid" lock file error after an unclean shutdown, and no postgres is running, remove the stale file: rm $HOMEBREW_PREFIX/var/postgresql@18/postmaster.pid |
GitHub Packages downloads:
| Last 30 days | 159,652 |
|---|---|
| Downloads | 1,151,113 |
| Analytics install events (30 days) | 16,459 |
| Downloads / install events (30 days) | 9.7× |
Source: GitHub Packages, fetched 2026-11-12T00:52:05Z. Analytics dates: 2026-10-13 to 2026-11-12. Totals exclude downloads from Bintray before the migration to GitHub Packages. Downloads and install attempts measure different things; the difference does not count analytics opt-outs. Definitions and limitations.
Analytics:
| 30 days | 90 days | 365 days | |
|---|---|---|---|
| Installs | 16,428 | 43,051 | 157,215 |
Installs (--HEAD) | 31 | 78 | 267 |
| Installs on Request | 16,076 | 42,133 | 152,037 |
Installs on Request (--HEAD) | 31 | 78 | 266 |
| Build Errors | 347 |