Exclude certain application pgaudit logging?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Exclude certain application pgaudit logging?
Дата
Msg-id CANzqJaAav-ycVS3zAGFsCD-1ft=2xUcNqXcihZk57=s4qhUZiw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Exclude certain application pgaudit logging?
Re: Exclude certain application pgaudit logging?
Список 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 по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Deleting duplicate rows using ctid ?
Следующее
От: Marcelo Marques
Дата:
Сообщение: Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common