Postgres Pro
Downloads
Home   >   mailing lists

Enable DB level audit trail - Mailing list pgsql-admin

From Wetmore, Matthew (CTR)
Subject Enable DB level audit trail
Date
Msg-id 6adb006a11144e4e87345447487a572c@evernorth.com
Whole thread Raw
In response to Re: Enable DB level audit trail  (Siraj G <tosiraj.g@gmail.com>)
List pgsql-admin
Tree view

Create a _hist table

 

From: Siraj G <tosiraj.g@gmail.com>
Sent: Tuesday, April 16, 2024 10:32 AM
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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@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: GF
Date:
Subject: Re: Enable DB level audit trail
Next
From: Paul Strauss
Date:
Subject: Database not appearing in PGadmin 4