MIME-Version: 1.0
References: 
 <CAFxeN6R5CQrxJiYXyj2qQjv-zKn6bO6+fbFgZ6jU5gWcF9zUJg@mail.gmail.com>
 <D975F27F-5AA8-42D5-A95C-0512AC3CA29E@elevated-dev.com>
In-Reply-To: <D975F27F-5AA8-42D5-A95C-0512AC3CA29E@elevated-dev.com>
From: Tejaswi K T <tejaswi.kt@gmail.com>
Date: Tue, 9 Apr 2024 15:03:56 +0200
Message-ID: 
 <CAFxeN6RDFiTEnVBzS6gthtJ0SwKTwgp0WHJ53ve2ecEFCMM5KQ@mail.gmail.com>
Subject: Re: Auditing in Postgres
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a772450615a98e6c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFxeN6RDFiTEnVBzS6gthtJ0SwKTwgp0WHJ53ve2ecEFCMM5KQ%40mail.gmail.com>
Precedence: bulk

--000000000000a772450615a98e6c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

=F0=9F=91=8D

Tejaswi K T reacted via Gmail
<https://www.google.com/gmail/about/?utm_source=3Dgmail-in-product&utm_medi=
um=3Det&utm_campaign=3Demojireactionemail#app>

On Tue, Apr 9, 2024 at 2:15=E2=80=AFPM Scott Ribe <scott_ribe@elevated-dev.=
com>
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.

--000000000000a772450615a98e6c
Content-Type: text/vnd.google.email-reaction+json; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

{
  "emoji": "=F0=9F=91=8D",
  "version": 1
}
--000000000000a772450615a98e6c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div><p style=3D"font-size:50px;margin-top:0;margin-bottom:0">=F0=9F=91=8D<=
/p><p style=3D"margin-top:10px;margin-bottom:0">Tejaswi K T reacted via <a =
href=3D"https://www.google.com/gmail/about/?utm_source=3Dgmail-in-product&a=
mp;utm_medium=3Det&amp;utm_campaign=3Demojireactionemail#app">Gmail</a></p>=
</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">=
On Tue, Apr 9, 2024 at 2:15=E2=80=AFPM Scott Ribe &lt;<a href=3D"mailto:sco=
tt_ribe@elevated-dev.com">scott_ribe@elevated-dev.com</a>&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left=
:1px #ccc solid;padding-left:1ex">&gt; Do we have similar commands in pgaud=
it , which captures only failed DML and not the successful ones. <br>
<br>
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 exampl=
e, but you can log all errors, then in your monitoring filter and classify =
them.</blockquote></div>

--000000000000a772450615a98e6c--