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çiOn Tue, Apr 15, 2025 at 1:44 PM vijay patil <vijay.postgres@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: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.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!ThanksVijay
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.
yours,Kenan ÇiftçiOn Tue, Apr 15, 2025 at 1:44 PM vijay patil <vijay.postgres@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: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.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!ThanksVijay
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: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.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!ThanksVijay
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:
pgaudit
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.
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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
