search

darold / pgbadger

A fast PostgreSQL Log Analyzer
http://pgbadger.darold.net/
PostgreSQL License
3.54k stars 353 forks source link

pgbouncer log format >= 1.11 not supported #565

Closed darold closed 4 years ago

darold commented 4 years ago

Hello. My setup:

My Issue:

pgbadger  -I -O /tmp/bouncer /var/log/pgbouncer/pgbouncer.log
FATAL: unable to detect log file format from /var/log/pgbouncer/pgbouncer.log, please use -f option.

When I add -f option badger still not working as expected. Produces blank html.

My log formant was like:

2020-02-16 03:43:05.469 TIMEZONE [12528]

After I reformatted log myself (removed tz and brackets) all works fine. I noticed that new logging format was added in 2019-08-27 - PgBouncer 1.11.0 - “Instinct for Greatness”

Originally posted by @dan-aksenov in https://github.com/darold/pgbadger/issues/558#issuecomment-587439408

darold commented 4 years ago

Good catch, commit 98d4c99 adds support to this new log format. Thanks.