# Install pgbadger with Homebrew, apk, apt, dnf, MacPorts, Nix, zypper

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/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-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/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst

## Package facts

- **Package key:** brew:pgbadger
- **Package manager:** Homebrew
- **Package manager page:** <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-07-08T07:18:31+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-07-08
- Package-manager version: 13.2
- Local data: ok
- Upstream repository: https://github.com/darold/pgbadger
- Upstream latest detected: v13.2 (current)
- info: No package-manager update timestamp was available.

## Security Notes

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

## Combined YAML source

View the package source record on GitHub. [combined/pgbadger.yml](https://github.com/automic-vault/db/blob/main/combined/pgbadger.yml)


## 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
