Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

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