| From: | "Wetmore, Matthew (CTR)" <Matthew(dot)Wetmore(at)evernorth(dot)com> |
|---|---|
| To: | Siraj G <tosiraj(dot)g(at)gmail(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Enable DB level audit trail |
| Date: | 2024-04-16 18:23:23 |
| Message-ID: | 6adb006a11144e4e87345447487a572c@evernorth.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Create a _hist table
From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
Sent: Tuesday, April 16, 2024 10:32 AM
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)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(at)gmail(dot)com<mailto: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<mailto: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<mailto:tosiraj(dot)g(at)gmail(dot)com>> wrote:
Hello Admins!
How do we enable DB level audit trail in PgSQL?
Regards
Siraj
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Strauss | 2024-04-18 02:29:53 | Database not appearing in PGadmin 4 |
| Previous Message | GF | 2024-04-16 18:11:28 | Re: Enable DB level audit trail |