macOS
Homebrewverified · 100%
brew install postgresql@14local Homebrew formula metadata
MacPortsverified · 94%
sudo port install postgresql14MacPorts ports tree · databases/postgresql14/Portfile · source: api.github.com
brew / rank 285
Install postgresql@14 with Homebrew, winget, chocolatey, MacPorts, zypper, scoop, apt, dnf, Nix, pacman
Object-relational database system. Version 14.24 via Homebrew; verified 2026-10-25. Also installable with winget: winget install --id PostgreSQL.PostgreSQL.14 -e.
install
Additional install commands
Linux
openSUSE zypperverified · 92%
sudo zypper install postgresql14openSUSE Tumbleweed package metadata · postgresql14 · source: download.opensuse.org
Debian aptverified · 92%
sudo apt install postgresqlDebian stable package indexes · postgresql · source: deb.debian.org
Fedora dnfverified · 92%
sudo dnf install postgresqlFedora Rawhide package metadata · postgresql · source: dl.fedoraproject.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.14 -eWindows Package Manager source index · PostgreSQL.PostgreSQL.14 · source: cdn.winget.microsoft.com
Chocolateyverified · 92%
choco install postgresql14Chocolatey community package catalog · postgresql14 · source: community.chocolatey.org
Scoopverified · 92%
scoop install versions/postgresql14Scoop official bucket manifest trees · bucket/postgresql14.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.
history
Project history and usage
PostgreSQL 14 is the 2021 major line of the long-running open-source object-relational database system, packaged with its server, interactive client, administration tools, backup utilities, and development interfaces.
Project history
PostgreSQL descends from the POSTGRES project begun at the University of California, Berkeley in 1986 under Michael Stonebraker. Andrew Yu and Jolly Chen added an SQL interpreter in 1994 and released the result as Postgres95; the community adopted the PostgreSQL name in 1996 to reflect both the POSTGRES lineage and SQL support.
PostgreSQL 14 added multiranges, JSONB subscripting, SQL-standard `SEARCH` and `CYCLE` clauses for common table expressions, stored-procedure output parameters, and performance improvements for concurrency, parallel queries, logical replication, and vacuuming.
Adoption history
PostgreSQL grew from a university research system into a community-maintained open-source database used for research and production workloads. The project describes PostgreSQL as having a strong reputation for reliability, data integrity, extensibility, and standards-oriented SQL support.
PostgreSQL 14 is a versioned major line released on September 30, 2021. PostgreSQL's five-year major-version support policy and requirement for explicit major-version upgrades encourage operating-system package collections to retain parallel, versioned packages for applications that cannot immediately migrate.
How it is used
Initialize and run a database cluster, connect interactively with `psql`, execute SQL from files or scripts, and use bundled tools such as `pg_dump`, `pg_restore`, `pg_basebackup`, `pgbench`, and `pg_upgrade`. Keep the current minor release within the PostgreSQL 14 line and plan major upgrades explicitly.
Why package nerds care
The versioned Homebrew formula gives administrators and developers a reproducible PostgreSQL 14 toolchain rather than silently moving a cluster across incompatible major storage formats. PostgreSQL major upgrades require dump/restore, `pg_upgrade`, or logical replication, making the selected major line operationally meaningful.
The package is more than the server: it includes `psql`, cluster initialization and control commands, backup and restore utilities, upgrade tooling, replication helpers, benchmarking tools, and database maintenance commands. That unusually complete toolkit is a major reason PostgreSQL packages are foundational components in development and operations environments.
Timeline
- 1986: Implementation of the Berkeley POSTGRES project began.
- 1994: Postgres95 added an SQL interpreter and was released as open source.
- 1996: The project adopted the PostgreSQL name and version 6.0 numbering.
- 2021-09-30: PostgreSQL 14 was released.
Related projects
- PostGIS extends PostgreSQL with spatial objects, indexes, and GIS processing. pgAdmin provides graphical administration and development, pgcli supplies an interactive terminal with contextual completion, and pgBackRest handles PostgreSQL backup, WAL archiving, and restore workflows.
Sources
- https://www.postgresql.org/docs/14/app-psql.html
- https://www.postgresql.org/docs/14/history.html
- https://www.postgresql.org/docs/14/release-14.html
- https://www.postgresql.org/support/versioning/
- source_facts.executables
- source_facts.package-manager.brew
security posture
No protected-tool coverage found yet
No matching local secret-handling manifest was found for postgresql@14. 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 5 platform targets.
- Installs with 5 runtime dependencies.
- Build metadata lists 1 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-11-04
manager version14.24
manager updated2026-10-25
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@14 |
|---|---|
| Version | 14.24 |
| Package manager | Homebrew |
| Package manager page | https://formulae.brew.sh/formula/postgresql@14 |
| Homepage | https://www.postgresql.org/ |
| Upstream docs | https://www.postgresql.org/ |
| License | PostgreSQL |
| Source archive | https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2 |
| Last updated | 2026-10-25T01:35:18Z |
| Pulse | updated |
| Dependencies | icu4c@79, krb5, lz4, openssl@4, readline |
| Build dependencies | pkgconf |
| Uses from macOS | libxml2, libxslt, openldap, perl |
| Bottle | available (on arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_tahoe, x86_64_linux) |
| Homebrew post-install | not defined |
| Service | declared |
| Caveats | If an old PostgreSQL data directory ($HOMEBREW_PREFIX/var/postgres) still exists, you can migrate to a versioned data directory by running: mv -v "$HOMEBREW_PREFIX/var/postgres" "$HOMEBREW_PREFIX/var/postgresql@14" (Make sure PostgreSQL is stopped before executing this command) This formula has created a default database cluster with: initdb --locale=en_US.UTF-8 -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@14 |
registry facts
Source database details
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | postgresql@14 |
| Version Scheme | 0 |
| Revision | 1 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | yes |
| Disabled | no |
| Keg Only | no |
| 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.
winget95%
PostgreSQL.PostgreSQL.14
winget install --id PostgreSQL.PostgreSQL.14 -e- normalized package name match
- Matched by: Postgresql 14
MacPorts94%
postgresql14
sudo port install postgresql14- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14 14.24-2.1
Basic Clients and Utilities for PostgreSQL
sudo zypper install postgresql14- License: PostgreSQL
- Category: Productivity/Databases/Tools
- Architecture: x86_64
- Source Package: postgresql14
- 10 dependencies
- 3 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-contrib 14.24-2.1
Contributed Extensions and Additions to PostgreSQL
sudo zypper install postgresql14-contrib- License: PostgreSQL
- Category: Productivity/Databases/Tools
- Architecture: x86_64
- Source Package: postgresql14
- 16 dependencies
- 2 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-devel 14.24-2.1
PostgreSQL client development header files and libraries
sudo zypper install postgresql14-devel- License: PostgreSQL
- Category: Development/Libraries/C and C++
- Architecture: x86_64
- Source Package: postgresql14
- 7 dependencies
- 5 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-docs 14.24-2.1
HTML Documentation for PostgreSQL
sudo zypper install postgresql14-docs- License: PostgreSQL
- Category: Productivity/Databases/Tools
- Architecture: noarch
- Source Package: postgresql14
- 1 dependencies
- 2 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-llvmjit 14.24-2.1
Just-in-time compilation support for PostgreSQL
sudo zypper install postgresql14-llvmjit- License: PostgreSQL
- Category: Productivity/Databases/Servers
- Architecture: x86_64
- Source Package: postgresql14
- 6 dependencies
- 2 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-llvmjit-devel 14.24-2.1
PostgreSQL development files for extensions with LLVM support
sudo zypper install postgresql14-llvmjit-devel- License: PostgreSQL
- Category: Development/Libraries/C and C++
- Architecture: x86_64
- Source Package: postgresql14
- 5 dependencies
- 3 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-plperl 14.24-2.1
The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL
sudo zypper install postgresql14-plperl- License: PostgreSQL
- Category: Productivity/Databases/Servers
- Architecture: x86_64
- Source Package: postgresql14
- 6 dependencies
- 2 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-plpython 14.24-2.1
The PL/Python Procedural Languages for PostgreSQL
sudo zypper install postgresql14-plpython- License: PostgreSQL
- Category: Productivity/Databases/Servers
- Architecture: x86_64
- Source Package: postgresql14
- 5 dependencies
- 2 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-pltcl 14.24-2.1
PL/Tcl Procedural Language for PostgreSQL
sudo zypper install postgresql14-pltcl- License: PostgreSQL
- Category: Productivity/Databases/Tools
- Architecture: x86_64
- Source Package: postgresql14
- 5 dependencies
- 2 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-server 14.24-2.1
The Programs Needed to Create and Run a PostgreSQL Server
sudo zypper install postgresql14-server- License: PostgreSQL
- Category: Productivity/Databases/Servers
- Architecture: x86_64
- Source Package: postgresql14
- 20 dependencies
- 3 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-server-devel 14.24-2.1
PostgreSQL server development header files and utilities
sudo zypper install postgresql14-server-devel- License: PostgreSQL
- Category: Development/Libraries/C and C++
- Architecture: x86_64
- Source Package: postgresql14
- 13 dependencies
- 4 provides
- package manager index match
- Matched by: Postgresql14
zypper92%
postgresql14-test 14.24-2.1
The test suite for PostgreSQL
sudo zypper install postgresql14-test- License: PostgreSQL
- Category: Productivity/Databases/Servers
- Architecture: x86_64
- Source Package: postgresql14
- 3 dependencies
- 2 provides
- package manager index match
- Matched by: Postgresql14
Chocolatey92%
postgresql14
choco install postgresql14- package manager index match
- Matched by: Postgresql14
Scoop92%
versions/postgresql14
scoop install versions/postgresql14- package manager index match
- Matched by: Postgresql14
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
- cross-ecosystem install command graph
- curated configuration and credential file locations
- curated package history
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment
- pkg.so package database
- pkgdb category and tag curation