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=xxxLOCATION: 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=xxxLOG: 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