Re: Auditing in Postgres

["Satish Chikkathammaiah [NMC - IT]" <satish.nayak@xxxxxx>]

@SOC [NMC - IT] @Anil Gowdar [NMC - IT] @NOC [NMC - IT]

Please look into it.

Thanks ,

Satish 

Get Outlook for iOS

---

From: Tejaswi K T <tejaswi.kt@xxxxxxxxx>
Sent: Tuesday, April 9, 2024 5:03:56 PM
To: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Auditing in Postgres

 

***This email was sent from a source outside of NMC***

Do NOT ACT on any instructions given on email unless you recognize the Sender, If in doubt please contact the Sender directly for confirmation.Do not click on links or open attachments unless you recognize the sender.

👍

Tejaswi K T reacted via Gmail

On Tue, Apr 9, 2024 at 2:15 PM Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:

> Do we have similar commands in pgaudit , which captures only failed DML and not the successful ones.

Not in pgaudit. Just in the standard PG config, in the logging section, you can choose if/how errors are logged. Not at the granularity of your example, but you can log all errors, then in your monitoring filter and classify them.

Classification: Restricted
Disclaimer: This e-mail message including any attachments is intended solely for the addressee(s) and may contain privileged information. If you have received
 this email by mistake, please notify the sender and delete the message destroying any hard copies of the original message. This message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the
 individual sender. NMC accepts no liability for any damage caused by any virus/worms transmitted by this email..