Hello, I think I just might did a small configuration issue, but somehow I cannot figure it out by myself.
I want to let pgbadger directly fetch data from journald -- so I was using with a unexpected outcome: $ pgbadger --journalctl "journalctl -u postgresql.service" LOG: Ok, generating html report...s: 0, events: 0 Having a look into the journal there is a lot of ---cut---- Mar 05 09:06:23 myhost postgres[441820]: 2024-03-05 08:06:23 GMT [441820]: user=[unknown],db=[unknown],app=[unknown],client=xxx LOCATION: BackendInitialize, postmaster.c:4373 Mar 05 09:06:23 myhost postgres[441820]: 2024-03-05 08:06:23 GMT [441820]: user=[unknown],db=[unknown],app=[unknown],client=xxx LOG: 00000: connection received: host=xxx port=34574 Mar 05 09:06:10 myhost postgres[441805]: 2024-03-05 08:06:10 GMT [441805]: user=postgres,db=xxx,app=psql,client=[local] LOCATION: log_disconnections, postgres.c:4722 Mar 05 09:06:10 myhost postgres[441805]: 2024-03-05 08:06:10 GMT [441805]: user=postgres,db=xxx,app=psql,client=[local] LOG: 00000: disconnection: session time: 0:00:00.016 user=postgres database=xxx host=[local] Mar 05 09:06:10 myhost postgres[441805]: 2024-03-05 08:06:10 GMT [441805]: user=postgres,db=xxx,app=[unknown],client=[local] LOCATION: PerformAuthentication, postinit.c:292 Mar 05 09:06:10 myhost postgres[441805]: 2024-03-05 08:06:10 GMT [441805]: user=postgres,db=xxx,app=[unknown],client=[local] LOG: 00000: connection authorized: user=postgres database=xxx application_name=psql ---cut--- My psotgresql.conf looks like: ---cut---- log_autovacuum_min_duration = 0 log_checkpoints = yes log_connections = yes log_destination = 'stderr' log_disconnections = yes log_error_verbosity = 'verbose' log_line_prefix = '%t [%p]: user=%u,db=%d,app=%a,client=%h ' log_lock_waits = yes log_min_duration_statement = 100 log_temp_files = 0 ---cut---- Any idea what I missed or did wrong? Cheers, Frank
