pgbadger

Install command:

brew install pgbadger

Log analyzer for PostgreSQL

https://pgbadger.darold.net/

License: PostgreSQL

Formula JSON API: /api/formula/pgbadger.json

Formula code: pgbadger.rb on GitHub

Bottle (binary package) installation support provided for:


Intel	ventura	✅
	monterey	✅
	big sur	✅
	64-bit linux	✅
Apple Silicon	ventura	✅
	monterey	✅
	big sur	✅

Current versions:

stable	✅	12.1
head	⚡️	HEAD

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'

Analytics (macOS):

Installs (30 days)
`pgbadger`	7
Installs on Request (30 days)
`pgbadger`	7
Build Errors (30 days)
`pgbadger`	0
Installs (90 days)
`pgbadger`	263
Installs on Request (90 days)
`pgbadger`	263
Installs (365 days)
`pgbadger`	1,933
Installs on Request (365 days)
`pgbadger`	1,929

Analytics (Linux):

Installs (30 days)
`pgbadger`	0
Installs on Request (30 days)
`pgbadger`	0
Build Errors (30 days)
`pgbadger`	0
Installs (90 days)
`pgbadger`	2
Installs on Request (90 days)
`pgbadger`	2
Installs (365 days)
`pgbadger`	18
Installs on Request (365 days)
`pgbadger`	18

Homebrew Formulae

pgbadger