Обсуждение: Enable DB level audit trail
Hello Admins!How do we enable DB level audit trail in PgSQL?RegardsSiraj
Hello Admins!How do we enable DB level audit trail in PgSQL?
Also, I would like to understand the implications of enabling the DB audit.Appreciate the help.RegardsSirajOn 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?RegardsSiraj
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.RegardsSirajOn 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?RegardsSiraj
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.RegardsSirajOn 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.RegardsSirajOn 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?RegardsSiraj
"Audit tables" are tables just like any other table, which means they can be changed by anyone with a superuser ROLE.
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