From: Vasukhi-ks (@Vasukhi-ks) <noreply+Vasukhi-ks@github.com>
To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>
Subject: [pgaudit/pgaudit] issue #281: Issues w.r.t to Azure Postgres Audit logging
Date: Mon, 28 Jul 2025 19:17:25 +0000
Message-ID: <gh-pgaudit-pgaudit-281@github.com> (raw)
Hello Team,
I have a scenario which i was testing for Azure Postgres Auditing for Postgres version 16.8 running on Azure.
Currently I am trying to achieve Database and Object level auditing for one particular Database.
Below are the steps which I have followed,
1. Set [pgaudit.log] at Server level to none.
2. ALTER DATABASE Vaccum set pgaudit.log='Read'; --- Set Auditing at DB Level.
3. ALTER ROLE readonly_role set pgaudit.log='Read'; --- Set Auditing at ROle level.
I was able to notice Audit logs for some of the transaction.
Later, I disable Auditing at Database and Role level and tried running few transactions.
Surprisingly I was still able to track transactions in my audit logs. Need to understand this behavior on why i am still able to notice transaction after i set audit log to None at both Database and Role level.
Would be great if anyone can help me on this.
Regards,
Vasukhi K S
Sharing few screenshots
<img width="1508" height="389" alt="Image" src="https://github.com/user-attachments/assets/8f8b08c8-35df-4c76-bd27-8abda3f1aab2"; />
<img width="887" height="597" alt="Image" src="https://github.com/user-attachments/assets/6aa68d17-f969-46b7-a279-7a648fa5bad1"; />