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

On 4/15/25 12:14, KENAN ÇİFTÇİ wrote:

Hi,

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

One issue we have with pgaudit is that it prints AUDIT records even if the xaction gets rollbacked, how do you alleviate that ?

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