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