# Install postgresql@18 with Homebrew, winget, apk, chocolatey, dnf, MacPorts, zypper, apt, Nix, pacman, scoop Object-relational database system. Version 18.4 via Homebrew; verified 2026-07-06. ## Install ```sh sudo av install brew:postgresql@18 ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install postgresql@18 ``` Evidence: local Homebrew formula metadata - MacPorts (94%): ```sh sudo port install postgresql18 ``` Evidence: MacPorts ports tree: databases/postgresql18/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ### Linux - apk (92%): ```sh sudo apk add libecpg ``` Evidence: Alpine Linux edge package indexes: libecpg from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz - 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 - zypper (92%): ```sh sudo zypper install libecpg6 ``` Evidence: openSUSE Tumbleweed package metadata: libecpg6 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.18 -e ``` Evidence: Windows Package Manager source index: PostgreSQL.PostgreSQL.18 from https://cdn.winget.microsoft.com/cache/source.msix - Chocolatey (92%): ```sh choco install postgresql18 ``` Evidence: Chocolatey community package catalog: postgresql18 from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','pingplotter' - Scoop (92%): ```sh scoop install main/postgresql ``` Evidence: Scoop official bucket manifest trees: bucket/postgresql.json from https://api.github.com/repos/ScoopInstaller/Main/git/trees/master?recursive=1 ## Package facts - **Package key:** brew:postgresql@18 - **Package manager:** Homebrew - **Package manager page:** - **Version:** 18.4 - **Source summary:** Object-relational database system - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** PostgreSQL - **Source archive:** - **Last updated:** 2026-07-06T17:36:31+01:00 - **Generated:** 2026-07-08T18:08:21+00:00 ## Dependencies - gettext - icu4c@78 - krb5 - lz4 - openssl@3 - readline - zstd ## Build dependencies - docbook - docbook-xsl - gettext - pkgconf ## Uses from macOS - curl - 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@18 When uninstalling, some dead symlinks are left behind so you may want to run: brew cleanup --prune-prefix - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## Freshness - Page generated: 2026-07-08 - Package-manager version: 18.4 - Package-manager updated: 2026-07-06 - 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@18. 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@18 - **Aliases:** postgres, postgresql - **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.18: normalized package name match | Windows Package Manager source index: PostgreSQL.PostgreSQL.18 from https://cdn.winget.microsoft.com/cache/source.msix - MacPorts - postgresql18: package manager index match | MacPorts ports tree: databases/postgresql18/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 - apk - libecpg - 18.4-r0: package manager index match | Alpine Linux edge package indexes: libecpg from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | ECPG - Embedded SQL in C | https://www.postgresql.org/ - apk - libecpg-dev - 18.4-r0: package manager index match | Alpine Linux edge package indexes: libecpg-dev from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | ECPG - Embedded SQL in C (development files) | https://www.postgresql.org/ - apk - libpq - 18.4-r0: package manager index match | Alpine Linux edge package indexes: libpq from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | PostgreSQL client library | https://www.postgresql.org/ - apk - libpq-dev - 18.4-r0: package manager index match | Alpine Linux edge package indexes: libpq-dev from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | PostgreSQL client library (development files) | https://www.postgresql.org/ - apk - postgresql18 - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18 from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | A sophisticated object-relational DBMS, version 18 | https://www.postgresql.org/ - apk - postgresql18-client - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18-client from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | PostgreSQL client | https://www.postgresql.org/ - apk - postgresql18-contrib - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18-contrib from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | Extension modules distributed with PostgreSQL | https://www.postgresql.org/ - apk - postgresql18-contrib-jit - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18-contrib-jit from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | Extension modules distributed with PostgreSQL (JIT support) | https://www.postgresql.org/ - apk - postgresql18-dev - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18-dev from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | A sophisticated object-relational DBMS, version 18 (development files) | https://www.postgresql.org/ - apk - postgresql18-doc - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18-doc from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | A sophisticated object-relational DBMS, version 18 (documentation) | https://www.postgresql.org/ - apk - postgresql18-jit - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18-jit from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | Just-in-time compilation support for PostgreSQL | https://www.postgresql.org/ - apk - postgresql18-openrc - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18-openrc from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | A sophisticated object-relational DBMS, version 18 (OpenRC init scripts) | https://www.postgresql.org/ - apk - postgresql18-plperl - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18-plperl from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | PL/Perl procedural language for PostgreSQL | https://www.postgresql.org/ - apk - postgresql18-plperl-contrib - 18.4-r0: package manager index match | Alpine Linux edge package indexes: postgresql18-plperl-contrib from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | PL/Perl extension modules distributed with PostgreSQL | https://www.postgresql.org/ ## Related links - [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. - [Archive and compression packages](https://www.automicvault.com/pkg/archive-compression-tools/) - Matched curated package taxonomy and local package facts. - [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. - [docbook](https://www.automicvault.com/pkg/brew/docbook/) - Build dependency declared by Homebrew. - [docbook-xsl](https://www.automicvault.com/pkg/brew/docbook-xsl/) - Build 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@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. ## Combined YAML source View the package source record on GitHub. [combined/postgresql@18.yml](https://github.com/automic-vault/db/blob/main/combined/postgresql@18.yml) ## Sources - Nucleus package database - package-page enrichment - curated configuration and credential file locations - package version freshness - package relationship graph - external package-manager database matches - cross-ecosystem install command graph