pgBadger with Pgaudit

From: Daulat <daulat(dot)dba(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: pgBadger with Pgaudit
Date: 2024-04-05 09:54:51
Message-ID: CALfOM6KreSTwHhOwnKPCdpCEa=E5aSJcjAy+T+-mQ=fD2EGuUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We are using pgaudit with our postgres v.14.6 with the following audit
options. But there are no details in the pgbadger report for insert, delete
and update while generating except select queries.

log_destination = 'csvlog'
logging_collector = on
log_directory = '/postgres/dblogs'
log_filename = 'postgresql_%A-%d-%B-%Y_%H%M'
log_truncate_on_rotation = on
log_rotation_size = 0
log_rotation_age = 1d
log_min_duration_statement = -1
log_checkpoints = on
log_connections = on
log_disconnections = on
log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h'
log_lock_waits = on
log_statement = 'none'
log_timezone = 'US/Eastern'
timezone = 'US/Eastern'

pgaudit.log = 'ddl,write'
pgaudit.log_relation = 'on'
shared_preload_libraries = 'pgaudit'

Does the pgbadger tool support DML operations /queries in their report?

If yes , please suggest how we can do it.

Thanks,
Daulat

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Samed YILDIRIM 2024-04-05 09:55:54 Re: Table DML status check per day
Previous Message Jonathan Schaeffer 2024-04-05 08:07:35 Managing replication lag