macOS
Homebrewverifiziert · 100%
brew install pgbadgerlocal Homebrew formula metadata
MacPortsverifiziert · 94%
sudo port install pgbadgerMacPorts ports tree · databases/pgbadger/Portfile · Quelle: api.github.com
brew / Rang 5176
pgbadger mit Homebrew, apk, apt, dnf, MacPorts, Nix, zypper installieren
Prüfe Installationswege, Executables, Metadaten und Sicherheitshinweise für pgbadger in AI-Agent-Workflows.
Installation
Weitere Installationsbefehle
Linux
Alpine Linux apkverifiziert · 92%
sudo apk add pgbadgerAlpine Linux edge package indexes · pgbadger · Quelle: dl-cdn.alpinelinux.org
Debian aptverifiziert · 92%
sudo apt install pgbadgerDebian stable package indexes · pgbadger · Quelle: deb.debian.org
Fedora dnfverifiziert · 92%
sudo dnf install pgbadgerFedora Rawhide package metadata · pgbadger · Quelle: dl.fedoraproject.org
Nixverifiziert · 92%
nix profile install nixpkgs#pgbadgernixpkgs package indexes · pgbadger · Quelle: raw.githubusercontent.com
openSUSE zypperverifiziert · 92%
sudo zypper install pgbadgeropenSUSE Tumbleweed package metadata · pgbadger · Quelle: download.opensuse.org
Überblick
Paketzusammenfassung
Log analyzer for PostgreSQL
Projektlinks
Befehle und Aliase
- pgbadger
Verlauf
Projektgeschichte und Nutzung
pgBadger is an offline PostgreSQL log analyzer that generates interactive HTML and other report formats for query performance, sessions, locks, checkpoints, autovacuum, errors, and related operational activity.
Projektgeschichte
Gilles Darold created pgBadger as a fast PostgreSQL log analyzer and released its early series in 2012. It was positioned as a replacement for the older pgFouine workflow and used JavaScript-rendered graphs in self-contained reports.
The project added incremental reporting, additional log formats, richer performance and error analysis, and multiple machine-readable outputs while retaining a command-line workflow and PostgreSQL license.
Adoptionsgeschichte
pgBadger's single-command, pure-Perl design and ability to work from existing log files made it straightforward to package and run on database hosts, reporting hosts, and administrative workstations. source_facts.package-manager records availability across Homebrew and several major Unix distribution ecosystems.
Support expanded beyond ordinary PostgreSQL stderr logs to formats and environments including csvlog, jsonlog, syslog, cloud-hosted PostgreSQL logs, compressed or remote inputs, and PgBouncer statistics logs.
Wie es verwendet wird
DBAs run pgBadger against one or more local, compressed, remote, or streamed log inputs. Common uses include identifying slow or frequent queries, inspecting errors and lock activity, evaluating checkpoints and autovacuum, and generating scheduled daily or weekly reports.
Warum Paket-Nerds sich dafür interessieren
pgBadger represents the classic Unix package pattern of converting already-available operational text into a portable artifact. It provides deep PostgreSQL-specific analysis and shareable HTML reports without requiring a permanently running agent or monitoring service.
Zeitleiste
- 2012: The first pgBadger release series established the PostgreSQL log-analysis and HTML-report workflow.
- 2014: Incremental reporting enabled cumulative scheduled reports.
- 2018: The 10.x series introduced a redesigned reporting interface.
Related projects
- pgBadger complements live PostgreSQL activity monitors by providing retrospective analysis of retained logs. It also directly understands PgBouncer log formats, allowing the pooler and database logs to participate in the same reporting workflow.
Quellen
Sicherheitslage
Risikostufe: blue
broad file, network, media, or database tool signal.
Risikoklassifikator
blue Risiko · mittel Konfidenz · tool
Warum
- broad file, network, media, or database tool signal
Signale
- text:sql
Installationsverhalten
- In den Formelmetadaten ist kein Homebrew-Post-install-Hook erfasst.
- Homebrew-Bottle-Metadaten sind für 5 Plattformziele verfügbar.
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.
Executables
Installierte Executables
| Befehl | Art | Sichtbarkeit | Hinweis |
|---|---|---|---|
pgbadger | cli | globales Executable |
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-Version13.2
Manager aktualisiert2026-11-03
lokale DatenOK
Upstreamaktuell
neueste erkannte Versionv13.3
https://github.com/darold/pgbadger
- OKEs wurden keine Aktualitätswarnungen generiert.
Installationsmetadaten
Paketmetadaten
| Paketschlüssel | brew:pgbadger |
|---|---|
| Version | 13.2 |
| Paketmanager | Homebrew |
| Paketmanager-Seite | https://formulae.brew.sh/formula/pgbadger |
| Homepage | https://pgbadger.darold.net/ |
| Repository | https://github.com/darold/pgbadger |
| Upstream-Dokumentation | https://pgbadger.darold.net/ |
| Lizenz | PostgreSQL |
| Quellarchiv | https://github.com/darold/pgbadger/archive/refs/tags/v13.3.tar.gz |
| Zuletzt aktualisiert | 2026-11-03T11:38:39Z |
| Pulse | updated |
| Bottle | verfügbar (auf arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_tahoe, x86_64_linux) |
| Homebrew post-install | nicht definiert |
| Dienst | keiner deklariert |
| Einschränkungen | You must configure your PostgreSQL server before using pgBadger. Edit postgresql.conf (in $HOMEBREW_PREFIX/var/postgres if you use Homebrew's PostgreSQL), set the following parameters, and restart PostgreSQL: log_destination = 'stderr' log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d ' log_statement = 'none' log_duration = off log_min_duration_statement = 0 log_checkpoints = on log_connections = on log_disconnections = on log_lock_waits = on log_temp_files = 0 lc_messages = 'C' |
Registry-Fakten
Details aus der Quelldatenbank
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | pgbadger |
| Version Scheme | 0 |
| Revision | 0 |
| Head Version | HEAD |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
Source-Datenbank-Treffer
Andere Paketmanager-Einträge
Treffer stammen aus externen Paketmanager-Indizes und bleiben von lokalen Automic-Vault-Paketlinks getrennt.
Debian apt95%
pgbadger 13.1-1
Fast PostgreSQL log analysis report
https://dalibo.github.io/pgbadger/
sudo apt install pgbadger- Section: admin
- Architecture: all
- 3 Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Pgbadger
Nix95%
pgbadger
nix profile install nixpkgs#pgbadger- normalized package name match
- Abgeglichen nach: Pgbadger
Ubuntu apt95%
pgbadger 12.4-1
Fast PostgreSQL log analysis report
https://dalibo.github.io/pgbadger/
sudo apt install pgbadger- Section: universe/admin
- Architecture: all
- 3 Abhängigkeiten
- normalized package name match
- Abgeglichen nach: Pgbadger
apk95%
pgbadger 12.4-r1
A fast PostgreSQL Log Analyzer
https://github.com/darold/pgbadger
sudo apk add pgbadger- License: Custom
- Architecture: x86_64
- Source Package: pgbadger
- 1 stellt bereit
- normalized package name match
- Abgeglichen nach: Pgbadger
apk95%
pgbadger-doc 12.4-r1
A fast PostgreSQL Log Analyzer (documentation)
https://github.com/darold/pgbadger
sudo apk add pgbadger-doc- License: Custom
- Architecture: x86_64
- Source Package: pgbadger
- normalized package name match
- Abgeglichen nach: Pgbadger
dnf95%
pgbadger 13.2-4.fc45
PostgreSQL log analyzer with fully detailed reports and graphs
https://github.com/darold/pgbadger
sudo dnf install pgbadger- License: PostgreSQL AND MIT AND Artistic-2.0 AND OFL-1.1 AND CC-BY-3.0 AND GPL-2.0-only
- Category: Unspecified
- Architecture: noarch
- Source Package: pgbadger
- 2 Abhängigkeiten
- 1 stellt bereit
- normalized package name match
- Abgeglichen nach: Pgbadger
zypper95%
pgbadger 13.2-1.5
A fast PostgreSQL log analyzer
sudo zypper install pgbadger- License: MIT
- Category: System/Monitoring
- Architecture: noarch
- Source Package: pgbadger
- 3 Abhängigkeiten
- 2 stellt bereit
- normalized package name match
- Abgeglichen nach: Pgbadger
MacPorts95%
pgbadger
sudo port install pgbadger- normalized package name match
- Abgeglichen nach: Pgbadger
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
- Geiger risk classifier
- cross-ecosystem install command graph
- 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