Exclude certain application pgaudit logging?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Exclude certain application pgaudit logging?
Date: 2024-02-06 18:11:23
Message-ID: CANzqJaAav-ycVS3zAGFsCD-1ft=2xUcNqXcihZk57=s4qhUZiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.)

Responses

Browse pgsql-general by date

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