# Install postgresql@15 with Homebrew, winget, chocolatey, MacPorts, zypper, scoop, apt, dnf, Nix, pacman Object-relational database system. Version 15.18 via Homebrew; verified 2026-07-05. Also installable with winget: winget install --id PostgreSQL.PostgreSQL.15 -e. ## Install ```sh sudo av install brew:postgresql@15 ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install postgresql@15 ``` Evidence: local Homebrew formula metadata - MacPorts (94%): ```sh sudo port install postgresql15 ``` Evidence: MacPorts ports tree: databases/postgresql15/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ### Linux - zypper (92%): ```sh sudo zypper install postgresql15 ``` Evidence: openSUSE Tumbleweed package metadata: postgresql15 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 - dnf (92%): ```sh sudo dnf install postgresql ``` Evidence: Fedora Rawhide package metadata: postgresql from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst - 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.15 -e ``` Evidence: Windows Package Manager source index: PostgreSQL.PostgreSQL.15 from https://cdn.winget.microsoft.com/cache/source.msix - Chocolatey (92%): ```sh choco install postgresql15 ``` Evidence: Chocolatey community package catalog: postgresql15 from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','pingplotter' - Scoop (92%): ```sh scoop install versions/postgresql15 ``` Evidence: Scoop official bucket manifest trees: bucket/postgresql15.json from https://api.github.com/repos/ScoopInstaller/Versions/git/trees/master?recursive=1 ## Package facts - **Package key:** brew:postgresql@15 - **Package manager:** Homebrew - **Package manager page:** - **Version:** 15.18 - **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@15 - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## Freshness - Page generated: 2026-07-25 - Package-manager version: 15.18 - 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@15. 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@15 - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** yes - **URL Keys:** stable ## Other Package-Manager Records - winget - PostgreSQL.PostgreSQL.15: normalized package name match | Windows Package Manager source index: PostgreSQL.PostgreSQL.15 from https://cdn.winget.microsoft.com/cache/source.msix - MacPorts - postgresql15: package manager index match | MacPorts ports tree: databases/postgresql15/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 - zypper - postgresql15 - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15 from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | Basic Clients and Utilities for PostgreSQL | https://www.postgresql.org/ - zypper - postgresql15-contrib - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-contrib from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | Contributed Extensions and Additions to PostgreSQL | https://www.postgresql.org/ - zypper - postgresql15-devel - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-devel from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | PostgreSQL client development header files and libraries | https://www.postgresql.org/ - zypper - postgresql15-docs - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-docs from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | HTML Documentation for PostgreSQL | https://www.postgresql.org/ - zypper - postgresql15-llvmjit - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-llvmjit from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | Just-in-time compilation support for PostgreSQL | https://www.postgresql.org/ - zypper - postgresql15-llvmjit-devel - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-llvmjit-devel from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | PostgreSQL development files for extensions with LLVM support | https://www.postgresql.org/ - zypper - postgresql15-plperl - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-plperl from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL | https://www.postgresql.org/ - zypper - postgresql15-plpython - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-plpython from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | The PL/Python Procedural Languages for PostgreSQL | https://www.postgresql.org/ - zypper - postgresql15-pltcl - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-pltcl from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | PL/Tcl Procedural Language for PostgreSQL | https://www.postgresql.org/ - zypper - postgresql15-server - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-server from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | The Programs Needed to Create and Run a PostgreSQL Server | https://www.postgresql.org/ - zypper - postgresql15-server-devel - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-server-devel from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | PostgreSQL server development header files and utilities | https://www.postgresql.org/ - zypper - postgresql15-test - 15.18-1.1: package manager index match | openSUSE Tumbleweed package metadata: postgresql15-test from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst | The test suite for PostgreSQL | https://www.postgresql.org/ - Chocolatey - postgresql15: package manager index match | Chocolatey community package catalog: postgresql15 from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','pingplotter' - Scoop - versions/postgresql15: package manager index match | Scoop official bucket manifest trees: bucket/postgresql15.json from https://api.github.com/repos/ScoopInstaller/Versions/git/trees/master?recursive=1 ## 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@16](https://www.automicvault.com/pkg/brew/postgresql-16/) - 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@15.yml](https://github.com/automic-vault/db/blob/main/combined/postgresql@15.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