Automic VaultAutomic Vault

brew

使用 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

命令和别名

  • oid2name
  • postgres
  • postmaster
  • vacuumlo

安全态势

尚未找到受保护工具覆盖

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

安装行为

  • formula 元数据中未记录 Homebrew post-install 钩子。
  • formula 元数据声明了服务或守护进程块。
  • Homebrew bottle 元数据适用于 6 个平台目标。
  • 安装时包含 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

可执行文件

已安装的可执行文件

命令类型暴露范围备注
oid2namecli全局可执行文件
postgrescli全局可执行文件
postmastercli全局可执行文件
vacuumlocli全局可执行文件

新鲜度

版本和新鲜度

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

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

https://www.postgresql.org/

安装元数据

软件包元数据

软件包键brew:postgresql@14
版本14.23
软件包管理器Homebrew
软件包管理器页面https://formulae.brew.sh/formula/postgresql@14
主页https://www.postgresql.org/
仓库https://git.postgresql.org/gitweb?p=postgresql.git
上游文档https://www.postgresql.org/docs/14/index.html
许可证PostgreSQL
源码归档https://ftp.postgresql.org/pub/source/v14.23/postgresql-14.23.tar.bz2
最后更新2026-07-07T06:58:42Z
Pulseupdated
依赖icu4c@78, krb5, lz4, openssl@3, readline
构建依赖pkgconf
macOS 提供的库libxml2, libxslt, openldap, perl
Bottle可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, 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
Revision0
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.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-contrib 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-devel 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-docs 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-llvmjit 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-llvmjit-devel 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-plperl 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-plpython 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-pltcl 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-server 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-server-devel 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst
zypper92%

postgresql14-test 14.23-1.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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-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 http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','pingplotter'
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 归属。

相关工具

  • krb5Runtime dependency declared by Homebrew.
  • lz4Runtime dependency declared by Homebrew.
  • openssl@3Runtime dependency declared by Homebrew.
  • pkgconfBuild dependency declared by Homebrew.
  • postgresql@15Package name indicates the same formula family.
  • postgresql@16Package name indicates the same formula family.
  • postgresql@17Package name indicates the same formula family.
  • postgresql@18Package name indicates the same formula family.

相同工作流

  • mysqlShares av.db curated category or tags: cli, data, database, rdbms, server.
  • apgdiffShares av.db curated category or tags: cli, data, database, postgresql, sql.
  • doltgresShares av.db curated category or tags: cli, data, database, postgresql, sql.
  • lazysqlShares av.db curated category or tags: cli, data, database, postgresql, sql.

来源线索

由仓库数据生成

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

使用的来源

  • Nucleus package database
  • av.db category and tag curation
  • cross-ecosystem install command graph
  • curated configuration and credential file locations
  • external package-manager database matches
  • package relationship graph
  • package version freshness
  • package-page enrichment