postgresql

Install command:
brew install postgresql

Also known as: postgres, postgresql@14

Object-relational database system

https://www.postgresql.org/

License: PostgreSQL

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

Bottle JSON API: /api/bottle/postgresql.json

Formula code: postgresql.rb on GitHub

Bottle (binary package) installation support provided for:

Intel monterey
big sur
catalina
64-bit linux
Apple Silicon monterey
big sur

Current versions:

stable 14.5
head ⚡️ HEAD

Other versions:

postgresql@13 13.8 Object-relational database system
postgresql@12 12.12 Object-relational database system
postgresql@11 11.17 Object-relational database system
postgresql@10 10.22 Object-relational database system
postgresql@9.6 9.6.24 Object-relational database system
postgresql@9.5 9.5.25 Object-relational database system
postgresql@9.4 9.4.26 Object-relational database system

Depends on:

icu4c 70.1 C/C++ and Java libraries for Unicode and globalization
krb5 1.20 Network authentication protocol
lz4 1.9.4 Extremely Fast Compression algorithm
openssl@1.1 1.1.1q Cryptography and SSL/TLS Toolkit
readline 8.1.2 Library for command-line editing

Depends on when building from source:

pkg-config 0.29.2 Manage compile and link flags for libraries
To migrate existing data from a previous major version of PostgreSQL run:
    brew postgresql-upgrade-database

This formula has created a default database cluster with:
    initdb --locale=C -E UTF-8 $(brew --prefix)/var/postgres
For more details, read:
    https://www.postgresql.org/docs/14/app-initdb.html

Analytics (macOS):

Installs (30 days)
postgresql 135,915
postgresql --HEAD 2
Installs on Request (30 days)
postgresql 132,100
postgresql --HEAD 2
Build Errors (30 days)
postgresql 35
Installs (90 days)
postgresql 400,910
postgresql --HEAD 12
PostgreSQL 1
Installs on Request (90 days)
postgresql 388,450
postgresql --HEAD 12
PostgreSQL 1
Installs (365 days)
postgresql 1,583,163
postgresql --HEAD 77
PostgreSQL 1
Installs on Request (365 days)
postgresql 1,528,483
postgresql --HEAD 77
PostgreSQL 1

Analytics (Linux):

Installs (30 days)
postgresql 887
Installs on Request (30 days)
postgresql 845
Build Errors (30 days)
postgresql 3
Installs (90 days)
postgresql 2,532
Installs on Request (90 days)
postgresql 2,402
Installs (365 days)
postgresql 9,930
Installs on Request (365 days)
postgresql 9,307
Fork me on GitHub