Re: Enable DB level audit trail

[Siraj G <tosiraj.g@xxxxxxxxx>]

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