# Install pgbadger

Log analyzer for PostgreSQL. Version 13.2 via Homebrew; verified from local package data.

## Install

```sh
sudo av install brew:pgbadger
```

Additional install commands:

### macOS

- Homebrew (100%):

```sh
brew install pgbadger
```

  Evidence: local Homebrew formula metadata

- MacPorts (94%):

```sh
sudo port install pgbadger
```

  Evidence: MacPorts ports tree: databases/pgbadger/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1

### Linux

- apk (92%):

```sh
sudo apk add pgbadger
```

  Evidence: Alpine Linux edge package indexes: pgbadger from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz

- Debian apt (92%):

```sh
sudo apt install pgbadger
```

  Evidence: Debian stable package indexes: pgbadger from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz

- dnf (92%):

```sh
sudo dnf install pgbadger
```

  Evidence: Fedora Rawhide package metadata: pgbadger from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/13ee7b80cb813542594d4235c4a0b8695435d5ecf23dd3580bc7515ae1b6180d-primary.xml.zst

- Nix (92%):

```sh
nix profile install nixpkgs#pgbadger
```

  Evidence: nixpkgs package indexes: pgbadger from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix

- zypper (92%):

```sh
sudo zypper install pgbadger
```

  Evidence: openSUSE Tumbleweed package metadata: pgbadger from https://download.opensuse.org/tumbleweed/repo/oss/repodata/155b97171d05e27afd950b6fe0d55513ff38f4597110664535bceedc680bbe6fd459f0733718dcc21dcf0efc7c8250fd1390c73d4790b42e62fb2c16a87242e5-primary.xml.zst

## Package Facts

- **Package key:** brew:pgbadger
- **Package manager:** Homebrew
- **Package manager URL:** <https://formulae.brew.sh/formula/pgbadger>
- **Version:** 13.2
- **Source summary:** Log analyzer for PostgreSQL
- **Homepage:** <https://pgbadger.darold.net/>
- **Repository:** <https://github.com/darold/pgbadger>
- **Upstream docs:** <https://github.com/darold/pgbadger/blob/master/README.md>
- **License:** PostgreSQL
- **Source archive:** <https://github.com/darold/pgbadger/archive/refs/tags/v13.2.tar.gz>
- **Generated:** 2026-06-10T07:18:26+00:00

## Executables

- pgbadger (cli)
- pgbadger (alias)

## Install Behavior

- Post-install hook: not defined
- Caveats: 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'
- Bottle: available on all

## Freshness

- Page generated: 2026-06-10
- Package-manager version: 13.2
- Local data status: ok
- Upstream repository: https://github.com/darold/pgbadger
- Upstream latest detected: v13.2 (current)
- info: No package-manager update timestamp was available.

## セキュリティノート

broad file, network, media, or database tool signal.

- **Geiger risk:** blue / medium
- broad file, network, media, or database tool signal

## Source Database Details

- **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:** head, stable

## Other Package-Manager Records

- Debian apt - pgbadger - 13.1-1: normalized package name match | Debian stable package indexes: pgbadger from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | Fast PostgreSQL log analysis report | https://dalibo.github.io/pgbadger/
- Nix - pgbadger: normalized package name match | nixpkgs package indexes: pgbadger from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix
- Ubuntu apt - pgbadger - 12.4-1: normalized package name match | Ubuntu 24.04 LTS package indexes: pgbadger from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | Fast PostgreSQL log analysis report | https://dalibo.github.io/pgbadger/
- apk - pgbadger - 12.4-r1: normalized package name match | Alpine Linux edge package indexes: pgbadger from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | A fast PostgreSQL Log Analyzer | https://github.com/darold/pgbadger
- apk - pgbadger-doc - 12.4-r1: normalized package name match | Alpine Linux edge package indexes: pgbadger-doc from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | A fast PostgreSQL Log Analyzer (documentation) | https://github.com/darold/pgbadger
- dnf - pgbadger - 13.2-2.fc45: normalized package name match | Fedora Rawhide package metadata: pgbadger from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/13ee7b80cb813542594d4235c4a0b8695435d5ecf23dd3580bc7515ae1b6180d-primary.xml.zst | PostgreSQL log analyzer with fully detailed reports and graphs | https://github.com/darold/pgbadger
- zypper - pgbadger - 13.2-1.3: normalized package name match | openSUSE Tumbleweed package metadata: pgbadger from https://download.opensuse.org/tumbleweed/repo/oss/repodata/155b97171d05e27afd950b6fe0d55513ff38f4597110664535bceedc680bbe6fd459f0733718dcc21dcf0efc7c8250fd1390c73d4790b42e62fb2c16a87242e5-primary.xml.zst | A fast PostgreSQL log analyzer | https://pgbadger.darold.net/
- MacPorts - pgbadger: normalized package name match | MacPorts ports tree: databases/pgbadger/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1


## Related Links

- [Secret-risk packages](https://www.automicvault.com/ja/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals.
- [Terminal utility packages](https://www.automicvault.com/ja/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://www.automicvault.com/ja/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [Developer build packages](https://www.automicvault.com/ja/pkg/developer-build-tools/) - Matched build, compiler, generator, or developer workflow metadata.
- [pg_top](https://www.automicvault.com/ja/pkg/brew/pg-top/) - Shares av.db curated category or tags: cli, database, developer-tools, performance, postgresql.
- [pgcli](https://www.automicvault.com/ja/pkg/brew/pgcli/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql.
- [pgbouncer](https://www.automicvault.com/ja/pkg/brew/pgbouncer/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql.
- [pg_partman](https://www.automicvault.com/ja/pkg/brew/pg-partman/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql.
- [pgbackrest](https://www.automicvault.com/ja/pkg/brew/pgbackrest/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql.
- [pg-schema-diff](https://www.automicvault.com/ja/pkg/brew/pg-schema-diff/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql.
- [pgcopydb](https://www.automicvault.com/ja/pkg/brew/pgcopydb/) - Shares av.db curated category or tags: cli, database, developer-tools, postgresql.
- [sqlbench](https://www.automicvault.com/ja/pkg/brew/sqlbench/) - Shares av.db curated category or tags: cli, database, developer-tools, performance, postgresql.

## Sources

- Nucleus package database
- Geiger risk classifier
- package-page enrichment
- package version freshness
- av.db category and tag curation
- package relationship graph
- external package-manager database matches
- cross-ecosystem install command graph
