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
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 |