pkg.soopen package index

brew / 排名 285

使用 Homebrew, winget, chocolatey, MacPorts, zypper, scoop, apt, dnf, Nix, pacman 安装 postgresql@14

查看 postgresql@14 的安装路径、可执行文件、元数据以及面向 AI 代理工作流的安全说明。

安装命令安全说明

安装

其他安装命令

macOS

Homebrew已验证 · 100%
brew install postgresql@14

local Homebrew formula metadata

MacPorts已验证 · 94%
sudo port install postgresql14

MacPorts ports tree · databases/postgresql14/Portfile · 来源: api.github.com

Linux

openSUSE zypper已验证 · 92%
sudo zypper install postgresql14

openSUSE Tumbleweed package metadata · postgresql14 · 来源: download.opensuse.org

Debian apt已验证 · 92%
sudo apt install postgresql

Debian stable package indexes · postgresql · 来源: deb.debian.org

Fedora dnf已验证 · 92%
sudo dnf install postgresql

Fedora Rawhide package metadata · postgresql · 来源: dl.fedoraproject.org

Nix已验证 · 92%
nix profile install nixpkgs#postgresql

nixpkgs package indexes · postgresql · 来源: raw.githubusercontent.com

Arch Linux pacman已验证 · 92%
sudo pacman -S postgresql

Arch Linux sync databases · postgresql · 来源: geo.mirror.pkgbuild.com

Windows

Windows Package Manager已验证 · 92%
winget install --id PostgreSQL.PostgreSQL.14 -e

Windows Package Manager source index · PostgreSQL.PostgreSQL.14 · 来源: cdn.winget.microsoft.com

Chocolatey已验证 · 92%
choco install postgresql14

Chocolatey community package catalog · postgresql14 · 来源: community.chocolatey.org

Scoop已验证 · 92%
scoop install versions/postgresql14

Scoop official bucket manifest trees · bucket/postgresql14.json · 来源: api.github.com

概览

软件包摘要

Object-relational database system

命令和别名

本地软件包数据库中没有找到可执行别名。

历史

项目历史与用法

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.

项目历史

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.

采用历史

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.

使用方式

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.

为什么软件包爱好者会关心

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.

时间线

  • 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.

安全态势

尚未找到受保护工具覆盖

没有找到 postgresql@14 的匹配本地密钥处理 manifest。软件包元数据仍在此发布，以便未来覆盖拥有稳定的软件包 URL。

安装行为

  • formula 元数据中未记录 Homebrew post-install 钩子。
  • formula 元数据声明了服务或守护进程块。
  • Homebrew bottle 元数据适用于 5 个平台目标。
  • 安装时包含 5 个运行时依赖。
  • 构建元数据列出 1 个构建依赖。

建议审查

在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。

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

可执行文件

已安装的可执行文件

命令类型暴露范围备注
没有可执行文件数据。

新鲜度

版本和新鲜度

这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。

页面生成时间2026-11-04
管理器版本14.24
管理器更新时间2026-10-25
本地数据OK
上游not checked
检测到的最新版本未检测到

https://www.postgresql.org/

安装元数据

软件包元数据

软件包键brew:postgresql@14
版本14.24
软件包管理器Homebrew
软件包管理器页面https://formulae.brew.sh/formula/postgresql@14
主页https://www.postgresql.org/
上游文档https://www.postgresql.org/
许可证PostgreSQL
源码归档https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2
最后更新2026-10-25T01:35:18Z
Pulseupdated
依赖icu4c@79, krb5, lz4, openssl@4, readline
构建依赖pkgconf
macOS 提供的库libxml2, libxslt, openldap, perl
Bottle可用 (于 arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_tahoe, x86_64_linux)
Homebrew post-install未定义
服务declared
注意事项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

注册表事实

源数据库详情

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namepostgresql@14
Version Scheme0
Revision1
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedyes
Disabledno
Keg Onlyno
URL Keys
  • stable

源数据库匹配

其他软件包管理器记录

匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。

winget95%

PostgreSQL.PostgreSQL.14

winget install --id PostgreSQL.PostgreSQL.14 -e
  • normalized package name match
  • 匹配方式：Postgresql 14
Windows Package Manager source index · cdn.winget.microsoft.com · Windows Package Manager source index: PostgreSQL.PostgreSQL.14 from https://cdn.winget.microsoft.com/cache/source.msix
MacPorts94%

postgresql14

sudo port install postgresql14
  • package manager index match
  • 匹配方式：Postgresql14
MacPorts ports tree · api.github.com · MacPorts ports tree: databases/postgresql14/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1
zypper92%

postgresql14 14.24-2.1

Basic Clients and Utilities for PostgreSQL

https://www.postgresql.org/

sudo zypper install postgresql14
  • License: PostgreSQL
  • Category: Productivity/Databases/Tools
  • Architecture: x86_64
  • Source Package: postgresql14
  • 10 依赖
  • 3 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14 from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-contrib 14.24-2.1

Contributed Extensions and Additions to PostgreSQL

https://www.postgresql.org/

sudo zypper install postgresql14-contrib
  • License: PostgreSQL
  • Category: Productivity/Databases/Tools
  • Architecture: x86_64
  • Source Package: postgresql14
  • 16 依赖
  • 2 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-contrib from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-devel 14.24-2.1

PostgreSQL client development header files and libraries

https://www.postgresql.org/

sudo zypper install postgresql14-devel
  • License: PostgreSQL
  • Category: Development/Libraries/C and C++
  • Architecture: x86_64
  • Source Package: postgresql14
  • 7 依赖
  • 5 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-devel from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-docs 14.24-2.1

HTML Documentation for PostgreSQL

https://www.postgresql.org/

sudo zypper install postgresql14-docs
  • License: PostgreSQL
  • Category: Productivity/Databases/Tools
  • Architecture: noarch
  • Source Package: postgresql14
  • 1 依赖
  • 2 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-docs from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-llvmjit 14.24-2.1

Just-in-time compilation support for PostgreSQL

https://www.postgresql.org/

sudo zypper install postgresql14-llvmjit
  • License: PostgreSQL
  • Category: Productivity/Databases/Servers
  • Architecture: x86_64
  • Source Package: postgresql14
  • 6 依赖
  • 2 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-llvmjit from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-llvmjit-devel 14.24-2.1

PostgreSQL development files for extensions with LLVM support

https://www.postgresql.org/

sudo zypper install postgresql14-llvmjit-devel
  • License: PostgreSQL
  • Category: Development/Libraries/C and C++
  • Architecture: x86_64
  • Source Package: postgresql14
  • 5 依赖
  • 3 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-llvmjit-devel from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-plperl 14.24-2.1

The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL

https://www.postgresql.org/

sudo zypper install postgresql14-plperl
  • License: PostgreSQL
  • Category: Productivity/Databases/Servers
  • Architecture: x86_64
  • Source Package: postgresql14
  • 6 依赖
  • 2 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-plperl from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-plpython 14.24-2.1

The PL/Python Procedural Languages for PostgreSQL

https://www.postgresql.org/

sudo zypper install postgresql14-plpython
  • License: PostgreSQL
  • Category: Productivity/Databases/Servers
  • Architecture: x86_64
  • Source Package: postgresql14
  • 5 依赖
  • 2 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-plpython from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-pltcl 14.24-2.1

PL/Tcl Procedural Language for PostgreSQL

https://www.postgresql.org/

sudo zypper install postgresql14-pltcl
  • License: PostgreSQL
  • Category: Productivity/Databases/Tools
  • Architecture: x86_64
  • Source Package: postgresql14
  • 5 依赖
  • 2 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-pltcl from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-server 14.24-2.1

The Programs Needed to Create and Run a PostgreSQL Server

https://www.postgresql.org/

sudo zypper install postgresql14-server
  • License: PostgreSQL
  • Category: Productivity/Databases/Servers
  • Architecture: x86_64
  • Source Package: postgresql14
  • 20 依赖
  • 3 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-server from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-server-devel 14.24-2.1

PostgreSQL server development header files and utilities

https://www.postgresql.org/

sudo zypper install postgresql14-server-devel
  • License: PostgreSQL
  • Category: Development/Libraries/C and C++
  • Architecture: x86_64
  • Source Package: postgresql14
  • 13 依赖
  • 4 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-server-devel from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
zypper92%

postgresql14-test 14.24-2.1

The test suite for PostgreSQL

https://www.postgresql.org/

sudo zypper install postgresql14-test
  • License: PostgreSQL
  • Category: Productivity/Databases/Servers
  • Architecture: x86_64
  • Source Package: postgresql14
  • 3 依赖
  • 2 提供
  • package manager index match
  • 匹配方式：Postgresql14
openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: postgresql14-test from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst
Chocolatey92%

postgresql14

choco install postgresql14
  • package manager index match
  • 匹配方式：Postgresql14
Chocolatey community package catalog · community.chocolatey.org · Chocolatey community package catalog: postgresql14 from https://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','pnpm'
Scoop92%

versions/postgresql14

scoop install versions/postgresql14
  • package manager index match
  • 匹配方式：Postgresql14
Scoop official bucket manifest trees · api.github.com · Scoop official bucket manifest trees: bucket/postgresql14.json from https://api.github.com/repos/ScoopInstaller/Versions/git/trees/master?recursive=1

软件包图谱

链接来自本地软件包关系图、补充数据、依赖边、生态匹配和软件包 hub 归属。

相同工作流

来源线索

由仓库数据生成

此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。

使用的来源

  • 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