Exclude certain application pgaudit logging?

2024-02-06 Thread Ron Johnson
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 mean

Re: Exclude certain application pgaudit logging?

2024-02-06 Thread Adrian Klaver
On 2/6/24 10:11 AM, Ron Johnson wrote: 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.) Using what audit software? The problem is that the application legitimately read

Re: Exclude certain application pgaudit logging?

2024-02-06 Thread Christophe Pettus
> On Feb 6, 2024, at 10:11, Ron Johnson wrote: > 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.) pgAudit doesn't currently include filters by appl

Re: Exclude certain application pgaudit logging?

2024-02-06 Thread Adrian Klaver
On 2/6/24 10:18 AM, Adrian Klaver wrote: On 2/6/24 10:11 AM, Ron Johnson wrote: 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.) Using what audit software? Memo to sel