Enable DB level audit trail

Поиск
Список
Период
Сортировка
От Wetmore, Matthew (CTR)
Тема Enable DB level audit trail
Дата
Msg-id 6adb006a11144e4e87345447487a572c@evernorth.com
обсуждение исходный текст
Ответ на Re: Enable DB level audit trail  (Siraj G <tosiraj.g@gmail.com>)
Список pgsql-admin
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: GF
Дата:
Сообщение: Re: Enable DB level audit trail
Следующее
От: Paul Strauss
Дата:
Сообщение: Database not appearing in PGadmin 4