Enable DB level audit trail

["Wetmore, Matthew (CTR)" <Matthew.Wetmore@xxxxxxxxxxxxx>]

Create a _hist table

 

From: Siraj G <tosiraj.g@xxxxxxxxx>
Sent: Tuesday, April 16, 2024 10:32 AM
To: Ron Johnson <ronljohnsonjr@xxxxxxxxx>
Cc: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: Enable DB level audit trail

 

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@xxxxxxxxx> wrote:

Lots of extra stuff in the postgresql log files.

 

On Mon, Apr 8, 2024 at 3:56 AM Siraj G <tosiraj.g@xxxxxxxxx> 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@xxxxxxxxx> wrote:

Hello Admins!

 

How do we enable DB level audit trail in PgSQL?

 

Regards

Siraj