macOS
Homebrewverifiziert · 100%
brew install postgresql@16local Homebrew formula metadata
MacPortsverifiziert · 94%
sudo port install postgresql16MacPorts ports tree · databases/postgresql16/Portfile · Quelle: api.github.com
brew / Rang 296
postgresql@16 mit Homebrew, apt, winget, apk, chocolatey, dnf, MacPorts, zypper, scoop, Nix, pacman installieren
Prüfe Installationswege, Executables, Metadaten und Sicherheitshinweise für postgresql@16 in AI-Agent-Workflows.
Installation
Weitere Installationsbefehle
Linux
Ubuntu aptverifiziert · 92%
sudo apt install postgresql-16Ubuntu 24.04 LTS package indexes · postgresql-16 · Quelle: archive.ubuntu.com
Alpine Linux apkverifiziert · 92%
sudo apk add postgresql16Alpine Linux edge package indexes · postgresql16 · Quelle: dl-cdn.alpinelinux.org
Fedora dnfverifiziert · 92%
sudo dnf install postgresql16Fedora Rawhide package metadata · postgresql16 · Quelle: dl.fedoraproject.org
openSUSE zypperverifiziert · 92%
sudo zypper install postgresql16openSUSE Tumbleweed package metadata · postgresql16 · Quelle: download.opensuse.org
Debian aptverifiziert · 92%
sudo apt install postgresqlDebian stable package indexes · postgresql · Quelle: deb.debian.org
Nixverifiziert · 92%
nix profile install nixpkgs#postgresqlnixpkgs package indexes · postgresql · Quelle: raw.githubusercontent.com
Arch Linux pacmanverifiziert · 92%
sudo pacman -S postgresqlArch Linux sync databases · postgresql · Quelle: geo.mirror.pkgbuild.com
Windows
Windows Package Managerverifiziert · 92%
winget install --id PostgreSQL.PostgreSQL.16 -eWindows Package Manager source index · PostgreSQL.PostgreSQL.16 · Quelle: cdn.winget.microsoft.com
Chocolateyverifiziert · 92%
choco install postgresql16Chocolatey community package catalog · postgresql16 · Quelle: community.chocolatey.org
Scoopverifiziert · 92%
scoop install versions/postgresql16Scoop official bucket manifest trees · bucket/postgresql16.json · Quelle: api.github.com
Überblick
Paketzusammenfassung
Object-relational database system
Projektlinks
Befehle und Aliase
In der lokalen Paketdatenbank wurden keine Executable-Aliase gefunden.
Verlauf
Projektgeschichte und Nutzung
PostgreSQL 16 is the 2023 major line of the open-source object-relational database system, packaged with its server and extensive client, operations, backup, and development utilities.
Projektgeschichte
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 16 added logical replication from standby servers, parallel application of large replicated transactions, the `pg_stat_io` monitoring view, additional SQL/JSON functions, and performance improvements in vacuuming and parallel joins.
Adoptionsgeschichte
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 16 is a versioned major line released on September 14, 2023. 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.
Wie es verwendet wird
Initialize and operate a database cluster, connect with `psql`, run SQL interactively or from 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 16 line and review compatibility notes before major upgrades.
Warum Paket-Nerds sich dafür interessieren
The versioned Homebrew formula gives administrators and developers a reproducible PostgreSQL 16 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 includes the server, `psql`, cluster administration commands, backup and restore utilities, upgrade tooling, replication helpers, benchmarking tools, and maintenance commands. PostgreSQL 16 is especially relevant for operators interested in `pg_stat_io`, logical replication from standbys, parallel subscription apply, and improved vacuum freezing.
Zeitleiste
- 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.
- 2023-09-14: PostgreSQL 16 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.
Quellen
- https://www.postgresql.org/docs/16/app-psql.html
- https://www.postgresql.org/docs/16/history.html
- https://www.postgresql.org/docs/16/release-16.html
- https://www.postgresql.org/support/versioning/
- source_facts.executables
- source_facts.package-manager.brew
Sicherheitslage
Noch keine Protected-Tool-Abdeckung gefunden
Für postgresql@16 wurde kein passendes lokales Secret-Handling-Manifest gefunden. Paketmetadaten bleiben hier veröffentlicht, damit künftige Abdeckung eine stabile Paket-URL hat.
Installationsverhalten
- In den Formelmetadaten ist kein Homebrew-Post-install-Hook erfasst.
- Formelmetadaten deklarieren einen Service- oder Daemon-Block.
- Homebrew-Bottle-Metadaten sind für 5 Plattformziele verfügbar.
- Installiert mit 7 Laufzeitabhängigkeiten.
- Build-Metadaten listen 2 Build-Abhängigkeiten.
Empfohlene Prüfung
Prüfe vor unbeaufsichtigter Agent-Nutzung, ob das Tool Klartext-Credentials liest, Remote-Zustand schreibt, Artefakte veröffentlicht oder Plugins ausführt.
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
Installierte Executables
| Befehl | Art | Sichtbarkeit | Hinweis |
|---|---|---|---|
| Es waren keine Executable-Daten vorhanden. | |||
Aktualität
Version und Aktualität
Diese Signale trennen das Alter der Seitengenerierung, Aktivität des Paketmanagers und Upstream-Release-Vergleich. Versionsrückstand wird nur gemeldet, wenn eine Evidenz-URL und vergleichbare Versionen vorhanden sind.
Seite generiert2026-11-04
Manager-Version16.15
Manager aktualisiert2026-10-25
lokale DatenOK
Upstreamnot checked
neueste erkannte Versionnicht erkannt
- InfoRelease/tag comparison is only available for GitHub repositories.https://www.postgresql.org/none Konfidenz
Installationsmetadaten
Paketmetadaten
| Paketschlüssel | brew:postgresql@16 |
|---|---|
| Version | 16.15 |
| Paketmanager | Homebrew |
| Paketmanager-Seite | https://formulae.brew.sh/formula/postgresql@16 |
| Homepage | https://www.postgresql.org/ |
| Upstream-Dokumentation | https://www.postgresql.org/ |
| Lizenz | PostgreSQL |
| Quellarchiv | https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2 |
| Zuletzt aktualisiert | 2026-10-25T01:07:48Z |
| Pulse | updated |
| Abhängigkeiten | gettext, icu4c@79, krb5, lz4, openssl@4, readline, zstd |
| Build-Abhängigkeiten | gettext, pkgconf |
| Von macOS bereitgestellte Bibliotheken | libxml2, libxslt, openldap, perl |
| Bottle | verfügbar (auf arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_tahoe, x86_64_linux) |
| Homebrew post-install | nicht definiert |
| Dienst | declared |
| Einschränkungen | This formula has created a default database cluster with: initdb --locale=en_US.UTF-8 -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@16 |
Registry-Fakten
Details aus der Quelldatenbank
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | postgresql@16 |
| Version Scheme | 0 |
| Revision | 1 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | yes |
| URL Keys |
|
Source-Datenbank-Treffer
Andere Paketmanager-Einträge
Treffer stammen aus externen Paketmanager-Indizes und bleiben von lokalen Automic-Vault-Paketlinks getrennt.
Ubuntu apt95%
libecpg-compat3 16.2-1ubuntu4
older version of run-time library for ECPG programs
sudo apt install libecpg-compat3- Section: libs
- Architecture: amd64
- Source Package: postgresql-16
- 3 Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
libecpg-dev 16.2-1ubuntu4
development files for ECPG (Embedded PostgreSQL for C)
sudo apt install libecpg-dev- Section: libdevel
- Architecture: amd64
- Source Package: postgresql-16
- 5 Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
libecpg6 16.2-1ubuntu4
run-time library for ECPG programs
sudo apt install libecpg6- Section: libs
- Architecture: amd64
- Source Package: postgresql-16
- 3 Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
libpgtypes3 16.2-1ubuntu4
shared library libpgtypes for PostgreSQL 16
sudo apt install libpgtypes3- Section: libs
- Architecture: amd64
- Source Package: postgresql-16
- 1 Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
libpq-dev 16.2-1ubuntu4
header files for libpq5 (PostgreSQL library)
sudo apt install libpq-dev- Section: libdevel
- Architecture: amd64
- Source Package: postgresql-16
- 2 Abhängigkeiten
- 1 optionale Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
libpq5 16.2-1ubuntu4
PostgreSQL C client library
sudo apt install libpq5- Section: libs
- Architecture: amd64
- Source Package: postgresql-16
- 4 Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
postgresql-16 16.2-1ubuntu4
The World's Most Advanced Open Source Relational Database
sudo apt install postgresql-16- Section: database
- Architecture: amd64
- 26 Abhängigkeiten
- 2 stellt bereit
- 1 optionale Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
postgresql-client-16 16.2-1ubuntu4
front-end programs for PostgreSQL 16
sudo apt install postgresql-client-16- Section: database
- Architecture: amd64
- Source Package: postgresql-16
- 9 Abhängigkeiten
- 1 stellt bereit
- 2 optionale Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
postgresql-doc-16 16.2-1ubuntu4
documentation for the PostgreSQL database management system
sudo apt install postgresql-doc-16- Section: doc
- Architecture: all
- Source Package: postgresql-16
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
postgresql-plperl-16 16.2-1ubuntu4
PL/Perl procedural language for PostgreSQL 16
sudo apt install postgresql-plperl-16- Section: database
- Architecture: amd64
- Source Package: postgresql-16
- 4 Abhängigkeiten
- 1 stellt bereit
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
postgresql-plpython3-16 16.2-1ubuntu4
PL/Python 3 procedural language for PostgreSQL 16
sudo apt install postgresql-plpython3-16- Section: database
- Architecture: amd64
- Source Package: postgresql-16
- 3 Abhängigkeiten
- 1 stellt bereit
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
postgresql-pltcl-16 16.2-1ubuntu4
PL/Tcl procedural language for PostgreSQL 16
sudo apt install postgresql-pltcl-16- Section: database
- Architecture: amd64
- Source Package: postgresql-16
- 3 Abhängigkeiten
- 1 stellt bereit
- normalized package name match
- Abgeglichen nach: Postgresql 16
Ubuntu apt95%
postgresql-server-dev-16 16.2-1ubuntu4
development files for PostgreSQL 16 server-side programming
sudo apt install postgresql-server-dev-16- Section: universe/libdevel
- Architecture: amd64
- Source Package: postgresql-16
- 5 Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Postgresql 16
winget95%
PostgreSQL.PostgreSQL.16
winget install --id PostgreSQL.PostgreSQL.16 -e- normalized package name match
- Abgeglichen nach: Postgresql 16
MacPorts94%
postgresql16
sudo port install postgresql16- package manager index match
- Abgeglichen nach: Postgresql16
apk92%
postgresql16 16.15-r0
A sophisticated object-relational DBMS, version 16
sudo apk add postgresql16- License: PostgreSQL
- Architecture: x86_64
- Source Package: postgresql16
- 1 Abhängigkeiten
- 1 stellt bereit
- package manager index match
- Abgeglichen nach: Postgresql16
Quellspur
Aus Repository-Daten generiert
Diese Seite wird von av-web aus dem privaten Paket-SQLite-Artefakt bereitgestellt, das scripts/generate-pkg-sqlite.py erstellt.
Combined YAML source
View the package source record on GitHub.
Verwendete Quellen
- 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