Postgres Pro
Downloads
Home   >   mailing lists

Re: Enable DB level audit trail - Mailing list pgsql-admin

From Siraj G
Subject Re: Enable DB level audit trail
Date
Msg-id CAC5iy63aoxZpA6PY24b+2GRu2c3wLWVbqgsk38=oUL0nDM1kiw@mail.gmail.com
Whole thread Raw
In response to Re: Enable DB level audit trail  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Enable DB level audit trail  (Ron Johnson <ronljohnsonjr@gmail.com>)
Enable DB level audit trail  ("Wetmore, Matthew (CTR)" <Matthew.Wetmore@evernorth.com>)
List pgsql-admin
Tree view
Thank you Ron.
Would it be good to use trigger based auditing or via pgAudit?
All we want is to capture changes in a few tables.

Regards
Siraj

On Mon, Apr 8, 2024 at 6:24 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
Lots of extra stuff in the postgresql log files.

On Mon, Apr 8, 2024 at 3:56 AM Siraj G <tosiraj.g@gmail.com> wrote:
Also, I would like to understand the implications of enabling the DB audit.

Appreciate the help.

Regards
Siraj

On Mon, Apr 8, 2024 at 11:30 AM Siraj G <tosiraj.g@gmail.com> wrote:
Hello Admins!

How do we enable DB level audit trail in PgSQL?

Regards
Siraj

pgsql-admin by date:

Previous
From: Samed YILDIRIM
Date:
Subject: Re: Postgresql - Pgbouncer Connection and Query Performance Problem
Next
From: Ron Johnson
Date:
Subject: Re: Enable DB level audit trail