# 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 ```sh sudo av install brew:postgresql@16 ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install postgresql@16 ``` Evidence: local Homebrew formula metadata - MacPorts (94%): ```sh sudo port install postgresql16 ``` Evidence: MacPorts ports tree: databases/postgresql16/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ### Linux - Ubuntu apt (92%): ```sh sudo apt install postgresql-16 ``` Evidence: Ubuntu 24.04 LTS package indexes: postgresql-16 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz - apk (92%): ```sh sudo apk add postgresql16 ``` Evidence: Alpine Linux edge package indexes: postgresql16 from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz - dnf (92%): ```sh sudo dnf install postgresql16 ``` Evidence: Fedora Rawhide package metadata: postgresql16 from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst - zypper (92%): ```sh sudo zypper install postgresql16 ``` Evidence: openSUSE Tumbleweed package metadata: postgresql16 from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst - Debian apt (92%): ```sh sudo apt install postgresql ``` Evidence: Debian stable package indexes: postgresql from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz - Nix (92%): ```sh nix profile install nixpkgs#postgresql ``` Evidence: nixpkgs package indexes: postgresql from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix - pacman (92%): ```sh sudo pacman -S postgresql ``` Evidence: Arch Linux sync databases: postgresql from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz ### Windows - winget (92%): ```sh winget install --id PostgreSQL.PostgreSQL.16 -e ``` Evidence: Windows Package Manager source index: PostgreSQL.PostgreSQL.16 from https://cdn.winget.microsoft.com/cache/source.msix - Chocolatey (92%): ```sh choco install postgresql16 ``` Evidence: Chocolatey community package catalog: postgresql16 from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','pingplotter' - Scoop (92%): ```sh scoop install versions/postgresql16 ``` Evidence: Scoop official bucket manifest trees: bucket/postgresql16.json from https://api.github.com/repos/ScoopInstaller/Versions/git/trees/master?recursive=1 ## Package facts - **Package key:** brew:postgresql@16 - **Package manager:** Homebrew - **Package manager page:** - **Version:** 16.14 - **Source summary:** Object-relational database system - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** PostgreSQL - **Source archive:** - **Last updated:** 2026-07-05T20:42:00+01:00 - **Generated:** 2026-07-25T07:20:51+00:00 ## Dependencies - gettext - icu4c@78 - krb5 - lz4 - openssl@3 - readline - zstd ## Build dependencies - gettext - pkgconf ## Uses from macOS - libxml2 - libxslt - openldap - perl ## Install behavior - Post-install hook: 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 - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## Freshness - Page generated: 2026-07-25 - Package-manager version: 16.14 - Package-manager updated: 2026-07-05 - Local data: ok - Upstream repository: https://www.postgresql.org/ - info: Release/tag comparison is only available for GitHub repositories. ## Security Notes 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. ## 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 - Unix: $PGDATA/postgresql.conf, $PGDATA/pg_hba.conf, $PGDATA/pg_ident.conf ## Credential files - Unix: ~/.pgpass - Windows: %APPDATA%\postgresql\pgpass.conf ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** postgresql@16 - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** yes - **URL Keys:** stable ## Other Package-Manager Records - Ubuntu apt - libecpg-compat3 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: libecpg-compat3 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | older version of run-time library for ECPG programs | http://www.postgresql.org/ - Ubuntu apt - libecpg-dev - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: libecpg-dev from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | development files for ECPG (Embedded PostgreSQL for C) | http://www.postgresql.org/ - Ubuntu apt - libecpg6 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: libecpg6 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | run-time library for ECPG programs | http://www.postgresql.org/ - Ubuntu apt - libpgtypes3 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: libpgtypes3 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | shared library libpgtypes for PostgreSQL 16 | http://www.postgresql.org/ - Ubuntu apt - libpq-dev - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: libpq-dev from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | header files for libpq5 (PostgreSQL library) | http://www.postgresql.org/ - Ubuntu apt - libpq5 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: libpq5 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | PostgreSQL C client library | http://www.postgresql.org/ - Ubuntu apt - postgresql-16 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: postgresql-16 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | The World's Most Advanced Open Source Relational Database | http://www.postgresql.org/ - Ubuntu apt - postgresql-client-16 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: postgresql-client-16 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | front-end programs for PostgreSQL 16 | http://www.postgresql.org/ - Ubuntu apt - postgresql-doc-16 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: postgresql-doc-16 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | documentation for the PostgreSQL database management system | http://www.postgresql.org/ - Ubuntu apt - postgresql-plperl-16 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: postgresql-plperl-16 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | PL/Perl procedural language for PostgreSQL 16 | http://www.postgresql.org/ - Ubuntu apt - postgresql-plpython3-16 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: postgresql-plpython3-16 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | PL/Python 3 procedural language for PostgreSQL 16 | http://www.postgresql.org/ - Ubuntu apt - postgresql-pltcl-16 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: postgresql-pltcl-16 from https://archive.ubuntu.com/ubuntu/dists/noble/main/binary-amd64/Packages.gz | PL/Tcl procedural language for PostgreSQL 16 | http://www.postgresql.org/ - Ubuntu apt - postgresql-server-dev-16 - 16.2-1ubuntu4: normalized package name match | Ubuntu 24.04 LTS package indexes: postgresql-server-dev-16 from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | development files for PostgreSQL 16 server-side programming | http://www.postgresql.org/ - winget - PostgreSQL.PostgreSQL.16: normalized package name match | Windows Package Manager source index: PostgreSQL.PostgreSQL.16 from https://cdn.winget.microsoft.com/cache/source.msix - MacPorts - postgresql16: package manager index match | MacPorts ports tree: databases/postgresql16/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 - apk - postgresql16 - 16.14-r0: package manager index match | Alpine Linux edge package indexes: postgresql16 from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | A sophisticated object-relational DBMS, version 16 | https://www.postgresql.org/ ## Related links - [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Networking and protocol packages](https://www.automicvault.com/pkg/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata. - [Database and data packages](https://www.automicvault.com/pkg/database-data-tools/) - Matched database, SQL, migration, or data-store metadata. - [gettext](https://www.automicvault.com/pkg/brew/gettext/) - Runtime dependency declared by Homebrew. - [krb5](https://www.automicvault.com/pkg/brew/krb5/) - Runtime dependency declared by Homebrew. - [lz4](https://www.automicvault.com/pkg/brew/lz4/) - Runtime dependency declared by Homebrew. - [openssl@3](https://www.automicvault.com/pkg/brew/openssl-3/) - Runtime dependency declared by Homebrew. - [zstd](https://www.automicvault.com/pkg/brew/zstd/) - Runtime dependency declared by Homebrew. - [pkgconf](https://www.automicvault.com/pkg/brew/pkgconf/) - Build dependency declared by Homebrew. - [postgresql@14](https://www.automicvault.com/pkg/brew/postgresql-14/) - Package name indicates the same formula family. - [postgresql@15](https://www.automicvault.com/pkg/brew/postgresql-15/) - Package name indicates the same formula family. - [postgresql@17](https://www.automicvault.com/pkg/brew/postgresql-17/) - Package name indicates the same formula family. - [postgresql@18](https://www.automicvault.com/pkg/brew/postgresql-18/) - Package name indicates the same formula family. - [mysql](https://www.automicvault.com/pkg/brew/mysql/) - Shares av.db curated category or tags: cli, data, database, rdbms, server. - [apgdiff](https://www.automicvault.com/pkg/brew/apgdiff/) - Shares av.db curated category or tags: cli, data, database, postgresql, sql. - [doltgres](https://www.automicvault.com/pkg/brew/doltgres/) - Shares av.db curated category or tags: cli, data, database, postgresql, sql. - [lazysql](https://www.automicvault.com/pkg/brew/lazysql/) - Shares av.db curated category or tags: cli, data, database, postgresql, sql. ## Combined YAML source View the package source record on GitHub. [combined/postgresql@16.yml](https://github.com/automic-vault/db/blob/main/combined/postgresql@16.yml) ## Sources - Nucleus package database - package-page enrichment - curated configuration and credential file locations - package version freshness - av.db category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph