postgresql

Also known as: postgres, postgresql@10

Object-relational database system

https://www.postgresql.org/

/api/formula/postgresql.json (JSON API)

Current versions:

stable	✅	10.5
head	⚡️	HEAD
bottle	🍾	mojave, high_sierra, sierra, el_capitan

Other versions:

postgresql@9.4	✅	9.4.19	Object-relational database system
postgresql@9.5	✅	9.5.14	Object-relational database system
postgresql@9.6	✅	9.6.10	Object-relational database system

Options:

--without-perl	Build without Perl support
--without-tcl	Build without Tcl support
--with-dtrace	Build with DTrace support
--with-python	Enable PL/Python3 (incompatible with --with-python@2)
--with-python@2	Enable PL/Python2

Depends on:

icu4c	✅	62.1	C/C++ and Java libraries for Unicode and globalization
openssl	✅	1.0.2p	SSL/TLS cryptography library
readline	✅	7.0.5	Library for command-line editing

Depends on optionally:

python	✅	3.7.0	Interpreted, interactive, object-oriented programming language
python@2	✅	2.7.15	Interpreted, interactive, object-oriented programming language

Depends on when building from source:

pkg-config

✅

0.29.2

Manage compile and link flags for libraries

Conflicts with: postgres-xc

Analytics:

Installs (30 days)
`postgresql`	53,022
`postgresql --with-python`	191
`postgresql --with-dtrace --with-python`	35
`postgresql --without-tcl`	19
`postgresql --without-perl`	16
`postgresql --with-python@2`	14
`postgresql --without-perl --without-tcl --with-python`	10
`postgresql --HEAD --with-python`	9
`postgresql --without-perl --without-tcl`	9
`postgresql --HEAD --without-perl --with-python@2`	8
`postgresql --HEAD`	7
`postgresql --HEAD --without-perl --with-python --with-python@2`	7
`postgresql --HEAD --without-perl --with-python`	5
`postgresql --with-dtrace`	5
`postgreSQL`	3
`postgresql --with-python --with-python@2`	3
`postgresql --with-dtrace --with-python@2`	2
`postgresql --without-perl --with-dtrace --with-python`	2
`postgresql --without-perl --without-tcl --with-dtrace`	2
Installs on Request (30 days)
`postgresql`	47,633
`postgresql --with-python`	174
`postgresql --with-dtrace --with-python`	34
`postgresql --without-perl`	15
`postgresql --with-python@2`	14
`postgresql --without-tcl`	12
`postgresql --HEAD --with-python`	9
`postgresql --without-perl --without-tcl`	9
`postgresql --without-perl --without-tcl --with-python`	9
`postgresql --HEAD --without-perl --with-python@2`	8
`postgresql --HEAD`	7
`postgresql --HEAD --without-perl --with-python --with-python@2`	7
`postgresql --HEAD --without-perl --with-python`	5
`postgresql --with-dtrace`	4
`postgreSQL`	3
`postgresql --with-python --with-python@2`	3
`postgresql --with-dtrace --with-python@2`	2
`postgresql --without-perl --with-dtrace --with-python`	2
`postgresql --without-perl --without-tcl --with-dtrace`	2
Build Errors (30 days)
`postgresql`	57
Installs (90 days)
`postgresql`	164,256
`postgresql --with-python`	673
`postgresql --with-dtrace --with-python`	164
`postgresql --without-tcl`	63
`postgresql --without-perl`	49
`postgresql --with-python@2`	42
`postgresql --without-perl --without-tcl`	36
`postgresql --with-dtrace`	27
`postgresql --without-perl --without-tcl --with-python`	25
`postgresql --HEAD`	19
`postgresql --with-python --with-python@2`	14
`postgresql --HEAD --with-python`	10
`postgresql --HEAD --with-dtrace --with-python`	8
`postgresql --HEAD --without-perl --with-python@2`	8
`postgresql --with-dtrace --with-python@2`	8
`postgresql --HEAD --without-perl --with-python`	7
`postgresql --HEAD --without-perl --with-python --with-python@2`	7
`postgresql --without-tcl --with-python`	7
`postgresql --without-perl --without-tcl --with-dtrace`	6
`postgreSQL`	4
`postgresql --without-perl --with-dtrace --with-python`	4
`postgresql --without-perl --without-tcl --with-dtrace --with-python`	4
`PostgreSQL`	3
`postgresql --without-perl --with-python`	3
Installs on Request (90 days)
`postgresql`	143,601
`postgresql --with-python`	583
`postgresql --with-dtrace --with-python`	152
`postgresql --without-perl`	45
`postgresql --with-python@2`	42
`postgresql --without-tcl`	37
`postgresql --without-perl --without-tcl`	33
`postgresql --without-perl --without-tcl --with-python`	23
`postgresql --HEAD`	19
`postgresql --with-dtrace`	16
`postgresql --with-python --with-python@2`	14
`postgresql --HEAD --with-python`	10
`postgresql --HEAD --with-dtrace --with-python`	8
`postgresql --HEAD --without-perl --with-python@2`	8
`postgresql --with-dtrace --with-python@2`	8
`postgresql --HEAD --without-perl --with-python`	7
`postgresql --HEAD --without-perl --with-python --with-python@2`	7
`postgresql --without-tcl --with-python`	7
`postgreSQL`	4
`postgresql --without-perl --with-dtrace --with-python`	4
`postgresql --without-perl --without-tcl --with-dtrace`	4
`PostgreSQL`	3
`postgresql --without-perl --with-python`	3
`postgresql --without-perl --without-tcl --with-dtrace --with-python`	3
Installs (365 days)
`postgresql`	678,848
`postgresql --with-python`	2,527
`postgresql --with-dtrace --with-python`	540
`postgresql --with-python3`	493
`postgresql --without-tcl`	425
`postgresql --without-perl`	256
`postgresql --without-perl --without-tcl`	143
`postgresql --with-dtrace --with-python3`	131
`postgresql --with-python@2`	123
`postgresql --with-dtrace`	100
`postgresql --without-perl --without-tcl --with-python`	76
`postgresql --with-python --with-python@2`	47
`postgresql --HEAD`	46
`postgresql --without-tcl --with-python`	30
`postgresql --without-perl --without-tcl --with-python3`	20
Installs on Request (365 days)
`postgresql`	559,576
`postgresql --with-python`	1,947
`postgresql --with-dtrace --with-python`	455
`postgresql --with-python3`	424
`postgresql --without-tcl`	267
`postgresql --without-perl`	222
`postgresql --with-python@2`	123
`postgresql --without-perl --without-tcl`	119
`postgresql --with-dtrace --with-python3`	116
`postgresql --without-perl --without-tcl --with-python`	65
`postgresql --with-dtrace`	54
`postgresql --HEAD`	46
`postgresql --with-python --with-python@2`	46
`postgresql --without-tcl --with-python`	26
`postgresql --without-perl --without-tcl --with-python3`	17

Homebrew Formulae

postgresql