Automic VaultAutomic Vault

brew

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

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

安装命令安全说明

安装

其他安装命令

macOS

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

local Homebrew formula metadata

MacPorts已验证 · 94%
sudo port install postgresql18

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

Linux

Alpine Linux apk已验证 · 92%
sudo apk add postgresql18

Alpine Linux edge package indexes · postgresql18 · 来源: dl-cdn.alpinelinux.org

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

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

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

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

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

Debian stable package indexes · postgresql · 来源: deb.debian.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.18 -e

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

Chocolatey已验证 · 92%
choco install postgresql18

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

Scoop已验证 · 92%
scoop install main/postgresql

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

概览

软件包摘要

Object-relational database system

命令和别名

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

安全态势

尚未找到受保护工具覆盖

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

安装行为

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

建议审查

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

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-07-25
管理器版本18.4
管理器更新时间2026-07-06
本地数据OK
上游not checked
检测到的最新版本未检测到

https://www.postgresql.org/

安装元数据

软件包元数据

软件包键brew:postgresql@18
版本18.4
软件包管理器Homebrew
软件包管理器页面https://formulae.brew.sh/formula/postgresql@18
主页https://www.postgresql.org/
仓库https://git.postgresql.org/gitweb?p=postgresql.git
上游文档https://www.postgresql.org/docs/18/index.html
许可证PostgreSQL
源码归档https://ftp.postgresql.org/pub/source/v18.4/postgresql-18.4.tar.bz2
最后更新2026-07-06T17:36:31+01:00
Pulseupdated
依赖gettext, icu4c@78, krb5, lz4, openssl@3, readline, zstd
构建依赖docbook, docbook-xsl, gettext, pkgconf
macOS 提供的库curl, libxml2, libxslt, openldap, perl
Bottle可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-install未定义
服务declared
注意事项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

注册表事实

源数据库详情

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namepostgresql@18
Aliases
  • postgres
  • postgresql
Version Scheme0
Revision0
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyyes
URL Keys
  • stable

源数据库匹配

其他软件包管理器记录

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

winget95%

PostgreSQL.PostgreSQL.18

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

postgresql18

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

libecpg 18.4-r0

ECPG - Embedded SQL in C

https://www.postgresql.org/

sudo apk add libecpg
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: libecpg from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

libecpg-dev 18.4-r0

ECPG - Embedded SQL in C (development files)

https://www.postgresql.org/

sudo apk add libecpg-dev
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: libecpg-dev from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

libpq 18.4-r0

PostgreSQL client library

https://www.postgresql.org/

sudo apk add libpq
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: libpq from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

libpq-dev 18.4-r0

PostgreSQL client library (development files)

https://www.postgresql.org/

sudo apk add libpq-dev
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: libpq-dev from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18 18.4-r0

A sophisticated object-relational DBMS, version 18

https://www.postgresql.org/

sudo apk add postgresql18
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18 from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18-client 18.4-r0

PostgreSQL client

https://www.postgresql.org/

sudo apk add postgresql18-client
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18-client from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18-contrib 18.4-r0

Extension modules distributed with PostgreSQL

https://www.postgresql.org/

sudo apk add postgresql18-contrib
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18-contrib from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18-contrib-jit 18.4-r0

Extension modules distributed with PostgreSQL (JIT support)

https://www.postgresql.org/

sudo apk add postgresql18-contrib-jit
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18-contrib-jit from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18-dev 18.4-r0

A sophisticated object-relational DBMS, version 18 (development files)

https://www.postgresql.org/

sudo apk add postgresql18-dev
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18-dev from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18-doc 18.4-r0

A sophisticated object-relational DBMS, version 18 (documentation)

https://www.postgresql.org/

sudo apk add postgresql18-doc
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18-doc from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18-jit 18.4-r0

Just-in-time compilation support for PostgreSQL

https://www.postgresql.org/

sudo apk add postgresql18-jit
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18-jit from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18-openrc 18.4-r0

A sophisticated object-relational DBMS, version 18 (OpenRC init scripts)

https://www.postgresql.org/

sudo apk add postgresql18-openrc
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18-openrc from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18-plperl 18.4-r0

PL/Perl procedural language for PostgreSQL

https://www.postgresql.org/

sudo apk add postgresql18-plperl
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18-plperl from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz
apk92%

postgresql18-plperl-contrib 18.4-r0

PL/Perl extension modules distributed with PostgreSQL

https://www.postgresql.org/

sudo apk add postgresql18-plperl-contrib
  • License: PostgreSQL
  • Architecture: x86_64
  • Source Package: postgresql18
  • 1 依赖
  • 1 提供
  • package manager index match
  • 匹配方式：Postgresql18
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: postgresql18-plperl-contrib from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz

软件包图谱

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

相关工具

  • gettextRuntime dependency declared by Homebrew.
  • krb5Runtime dependency declared by Homebrew.
  • lz4Runtime dependency declared by Homebrew.
  • openssl@3Runtime dependency declared by Homebrew.
  • zstdRuntime dependency declared by Homebrew.
  • docbookBuild dependency declared by Homebrew.
  • docbook-xslBuild dependency declared by Homebrew.
  • pkgconfBuild dependency declared by Homebrew.

相同工作流

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

来源线索

由仓库数据生成

此页面由 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