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@xxxxxxxxx> wrote:
Hi All,
We are exploring auditing solutions for our PostgreSQL database and are considering using
pgauditfor this purpose. However, we have a few questions:
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.
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
