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 | ✅ | |
| sonoma | ✅ | |
| macOS on Intel |
sonoma | ✅ |
| Linux | ARM64 | ✅ |
| x86_64 | ✅ |
Current versions:
| stable | ✅ | 18.6 |
Other versions:
| postgresql@17 | 17.11 | Object-relational database system |
| postgresql@16 | 16.15 | Object-relational database system |
| postgresql@15 | 15.19 | 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.3 | 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.7 | 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 |
Analytics:
| 30 days | 90 days | 365 days | |
|---|---|---|---|
| Installs | 14,640 | 42,802 | 136,413 |
Installs (--HEAD) | 29 | 76 | 226 |
| Installs on Request | 14,343 | 41,481 | 130,847 |
Installs on Request (--HEAD) | 29 | 76 | 225 |
| Build Errors | 368 |