Exclude certain application pgaudit logging? - Mailing list pgsql-general

From Ron Johnson
Subject Exclude certain application pgaudit logging?
Date
Msg-id CANzqJaAav-ycVS3zAGFsCD-1ft=2xUcNqXcihZk57=s4qhUZiw@mail.gmail.com
Whole thread Raw
Responses Re: Exclude certain application pgaudit logging?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Exclude certain application pgaudit logging?  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
Currently, we use Object audit logging to capture all READ access to columns FOO_1, FOO_2 and FOO_3 in table BAR.SCRABBLE.  (They are the three columns have PII data.)

The problem is that the application legitimately reads these columns thousands of times per day.  Thus, the log fills up with meaningless data that swamps any legitimate invalid accesses.

Thus, I'd like to exclude reads from "Postgresql JDBC Driver".  (Currently, I filter that out using "grep -v" in a shell script that runs hourly from cron, but I find that unsatisfactory.)

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Deleting duplicate rows using ctid ?
Next
From: Marcelo Marques
Date:
Subject: Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common