Re: Enable DB level audit trail

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Enable DB level audit trail
Date: 2024-04-16 17:32:19
Message-ID: CAC5iy63aoxZpA6PY24b+2GRu2c3wLWVbqgsk38=oUL0nDM1kiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)com> wrote:

> Lots of extra stuff in the postgresql log files.
>
> On Mon, Apr 8, 2024 at 3:56 AM Siraj G <tosiraj(dot)g(at)gmail(dot)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(dot)g(at)gmail(dot)com> wrote:
>>
>>> Hello Admins!
>>>
>>> How do we enable DB level audit trail in PgSQL?
>>>
>>> Regards
>>> Siraj
>>>
>>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-04-16 18:01:03 Re: Enable DB level audit trail
Previous Message Samed YILDIRIM 2024-04-16 16:10:11 Re: Postgresql - Pgbouncer Connection and Query Performance Problem