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

[Achilleas Mantzios - cloud]

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.postg...@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