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