pgBadger: Cannot find any log entries from systemd-journald

From: Frank Lanitz <frank(at)frank(dot)uvena(dot)de>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pgBadger: Cannot find any log entries from systemd-journald
Date: 2024-03-05 08:13:48
Message-ID: 84c14e3e-f4d7-436f-939f-f88d026743f5@frank.uvena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message M Tarkeshwar Rao 2024-03-05 11:07:03 Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy
Previous Message Andreas Joseph Krogh 2024-03-05 07:37:47 Sv: Support for dates before 4713 BC