macOS
Homebrewverified · 100%
brew install postgresql@16local Homebrew formula metadata
MacPortsverified · 94%
sudo port install postgresql16MacPorts ports tree · databases/postgresql16/Portfile · source: api.github.com
brew
Install postgresql@16 with Homebrew, apt, winget, apk, chocolatey, dnf, MacPorts, zypper, scoop, Nix, pacman
Object-relational database system. Version 16.14 via Homebrew; verified 2026-07-05. Also installable with ubuntu: sudo apt install libecpg-compat3.
install
Additional install commands
Linux
Ubuntu aptverified · 92%
sudo apt install postgresql-16Ubuntu 24.04 LTS package indexes · postgresql-16 · source: archive.ubuntu.com
Alpine Linux apkverified · 92%
sudo apk add postgresql16Alpine Linux edge package indexes · postgresql16 · source: dl-cdn.alpinelinux.org
Fedora dnfverified · 92%
sudo dnf install postgresql16Fedora Rawhide package metadata · postgresql16 · source: dl.fedoraproject.org
openSUSE zypperverified · 92%
sudo zypper install postgresql16openSUSE Tumbleweed package metadata · postgresql16 · source: download.opensuse.org
Debian aptverified · 92%
sudo apt install postgresqlDebian stable package indexes · postgresql · source: deb.debian.org
Nixverified · 92%
nix profile install nixpkgs#postgresqlnixpkgs package indexes · postgresql · source: raw.githubusercontent.com
Arch Linux pacmanverified · 92%
sudo pacman -S postgresqlArch Linux sync databases · postgresql · source: geo.mirror.pkgbuild.com
Windows
Windows Package Managerverified · 92%
winget install --id PostgreSQL.PostgreSQL.16 -eWindows Package Manager source index · PostgreSQL.PostgreSQL.16 · source: cdn.winget.microsoft.com
Chocolateyverified · 92%
choco install postgresql16Chocolatey community package catalog · postgresql16 · source: community.chocolatey.org
Scoopverified · 92%
scoop install versions/postgresql16Scoop official bucket manifest trees · bucket/postgresql16.json · source: api.github.com
overview
Package summary
Object-relational database system
Project links
Commands and aliases
No executable aliases were found in the local package database.
security posture
No protected-tool coverage found yet
No matching local secret-handling manifest was found for postgresql@16. Nucleus package metadata is still published here so future coverage has a stable package URL.
Install behavior
- No Homebrew post-install hook is recorded in formula metadata.
- Formula metadata declares a service or daemon block.
- Homebrew bottle metadata is available for 6 platform targets.
- Installs with 7 runtime dependencies.
- Build metadata lists 2 build dependencies.
Recommended review
Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.
local files
Configuration and credential file locations
These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.
Configuration files
Config paths the tool may read or write during local use.
- Unix
$PGDATA/postgresql.conf$PGDATA/pg_hba.conf$PGDATA/pg_ident.conf
Credential files
Credential-bearing paths to review before unattended agent runs.
- Unix
~/.pgpass- Windows
%APPDATA%\postgresql\pgpass.conf
executables
Installed executables
| Command | Kind | Exposure | Note |
|---|---|---|---|
| No executable data was present. | |||
freshness
Version and freshness
These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.
page generated2026-07-25
manager version16.14
manager updated2026-07-05
local dataok
upstreamnot checked
latest detectednot detected
- infoRelease/tag comparison is only available for GitHub repositories.https://www.postgresql.org/none confidence
install metadata
Package metadata
| Package key | brew:postgresql@16 |
|---|---|
| Version | 16.14 |
| Package manager | Homebrew |
| Package manager page | https://formulae.brew.sh/formula/postgresql@16 |
| Homepage | https://www.postgresql.org/ |
| Repository | https://git.postgresql.org/gitweb?p=postgresql.git |
| Upstream docs | https://www.postgresql.org/docs/16/index.html |
| License | PostgreSQL |
| Source archive | https://ftp.postgresql.org/pub/source/v16.14/postgresql-16.14.tar.bz2 |
| Last updated | 2026-07-05T20:42:00+01:00 |
| Pulse | updated |
| Dependencies | gettext, icu4c@78, krb5, lz4, openssl@3, readline, zstd |
| Build dependencies | gettext, pkgconf |
| Uses from macOS | libxml2, libxslt, openldap, perl |
| Bottle | available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux) |
| Homebrew post-install | not defined |
| Service | declared |
| Caveats | This formula has created a default database cluster with: initdb --locale=en_US.UTF-8 -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@16 |
registry facts
Source database details
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | postgresql@16 |
| Version Scheme | 0 |
| Revision | 0 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | yes |
| URL Keys |
|
source database matches
Other package-manager records
Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.
Ubuntu apt95%
libecpg-compat3 16.2-1ubuntu4
older version of run-time library for ECPG programs
sudo apt install libecpg-compat3- Section: libs
- Architecture: amd64
- Source Package: postgresql-16
- 3 dependencies
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
libecpg-dev 16.2-1ubuntu4
development files for ECPG (Embedded PostgreSQL for C)
sudo apt install libecpg-dev- Section: libdevel
- Architecture: amd64
- Source Package: postgresql-16
- 5 dependencies
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
libecpg6 16.2-1ubuntu4
run-time library for ECPG programs
sudo apt install libecpg6- Section: libs
- Architecture: amd64
- Source Package: postgresql-16
- 3 dependencies
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
libpgtypes3 16.2-1ubuntu4
shared library libpgtypes for PostgreSQL 16
sudo apt install libpgtypes3- Section: libs
- Architecture: amd64
- Source Package: postgresql-16
- 1 dependencies
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
libpq-dev 16.2-1ubuntu4
header files for libpq5 (PostgreSQL library)
sudo apt install libpq-dev- Section: libdevel
- Architecture: amd64
- Source Package: postgresql-16
- 2 dependencies
- 1 optional deps
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
libpq5 16.2-1ubuntu4
PostgreSQL C client library
sudo apt install libpq5- Section: libs
- Architecture: amd64
- Source Package: postgresql-16
- 4 dependencies
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
postgresql-16 16.2-1ubuntu4
The World's Most Advanced Open Source Relational Database
sudo apt install postgresql-16- Section: database
- Architecture: amd64
- 26 dependencies
- 2 provides
- 1 optional deps
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
postgresql-client-16 16.2-1ubuntu4
front-end programs for PostgreSQL 16
sudo apt install postgresql-client-16- Section: database
- Architecture: amd64
- Source Package: postgresql-16
- 9 dependencies
- 1 provides
- 2 optional deps
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
postgresql-doc-16 16.2-1ubuntu4
documentation for the PostgreSQL database management system
sudo apt install postgresql-doc-16- Section: doc
- Architecture: all
- Source Package: postgresql-16
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
postgresql-plperl-16 16.2-1ubuntu4
PL/Perl procedural language for PostgreSQL 16
sudo apt install postgresql-plperl-16- Section: database
- Architecture: amd64
- Source Package: postgresql-16
- 4 dependencies
- 1 provides
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
postgresql-plpython3-16 16.2-1ubuntu4
PL/Python 3 procedural language for PostgreSQL 16
sudo apt install postgresql-plpython3-16- Section: database
- Architecture: amd64
- Source Package: postgresql-16
- 3 dependencies
- 1 provides
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
postgresql-pltcl-16 16.2-1ubuntu4
PL/Tcl procedural language for PostgreSQL 16
sudo apt install postgresql-pltcl-16- Section: database
- Architecture: amd64
- Source Package: postgresql-16
- 3 dependencies
- 1 provides
- normalized package name match
- Matched by: Postgresql 16
Ubuntu apt95%
postgresql-server-dev-16 16.2-1ubuntu4
development files for PostgreSQL 16 server-side programming
sudo apt install postgresql-server-dev-16- Section: universe/libdevel
- Architecture: amd64
- Source Package: postgresql-16
- 5 dependencies
- normalized package name match
- Matched by: Postgresql 16
winget95%
PostgreSQL.PostgreSQL.16
winget install --id PostgreSQL.PostgreSQL.16 -e- normalized package name match
- Matched by: Postgresql 16
MacPorts94%
postgresql16
sudo port install postgresql16- package manager index match
- Matched by: Postgresql16
apk92%
postgresql16 16.14-r0
A sophisticated object-relational DBMS, version 16
sudo apk add postgresql16- License: PostgreSQL
- Architecture: x86_64
- Source Package: postgresql16
- 1 dependencies
- 1 provides
- package manager index match
- Matched by: Postgresql16
source trail
Generated from repository data
This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.
Combined YAML source
View the package source record on GitHub.
Used sources
- Nucleus package database
- av.db category and tag curation
- cross-ecosystem install command graph
- curated configuration and credential file locations
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment