← all formulas
pgbadger
Log analyzer for PostgreSQL
- Version
- v13.2
- License
- PostgreSQL
- Tap
- homebrew/core
- Bottle
- available
- Revision
- —
bottledlicense declaredhomepageactivekeg-linked
Install
shell
$ brew install pgbadgerCaveats
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'