Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

[vijay patil]

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