Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

Поиск
Список
Период
Сортировка
От KENAN ÇİFTÇİ
Тема Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately
Дата
Msg-id CAHsK0FqMEoZ_EL6bdHL=MO6irp3uXa5iC_T9jKuCgwRcOQ=Feg@mail.gmail.com
обсуждение исходный текст
Ответ на Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately  (vijay patil <vijay.postgres@gmail.com>)
Ответы Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately
Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately
Список pgsql-general
Дерево обсуждения
Hi,

You can use pgaudit and pgauditlogtofile extension (https://github.com/fmbiete/pgauditlogtofile) together to write audit logs in a separate file. 

yours,

Kenan Çiftçi

On Tue, Apr 15, 2025 at 1:44 PM vijay patil <vijay.postgres@gmail.com> wrote:

Hi All,

We are exploring auditing solutions for our PostgreSQL database and are considering using pgaudit for this purpose. However, we have a few questions:

  1. What is the best tool for auditing PostgreSQL databases?

    • We are specifically looking for a solution that offers detailed auditing capabilities and is compatible with our setup.

  2. Can we store the audit information separately from PostgreSQL logs if we decide to use pgaudit?

    • We would prefer to keep the audit logs in a separate file or location for easier management and analysis.


We appreciate any help or suggestions!


Thanks

Vijay

В списке pgsql-general по дате отправления: