From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Tejaswi K T <tejaswi.kt@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Auditing in Postgres
Date: Tue, 9 Apr 2024 06:15:20 -0600
Message-ID: <D975F27F-5AA8-42D5-A95C-0512AC3CA29E@elevated-dev.com> (raw)
In-Reply-To: <CAFxeN6R5CQrxJiYXyj2qQjv-zKn6bO6+fbFgZ6jU5gWcF9zUJg@mail.gmail.com>
References: <CAFxeN6R5CQrxJiYXyj2qQjv-zKn6bO6+fbFgZ6jU5gWcF9zUJg@mail.gmail.com>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, tejaswi.kt@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Auditing in Postgres
In-Reply-To: <D975F27F-5AA8-42D5-A95C-0512AC3CA29E@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox