Re: Using pgAudit to audit interesting tables for all users except for batch user?

From: "Colin 't Hart" <colinthart(at)gmail(dot)com>
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Using pgAudit to audit interesting tables for all users except for batch user?
Date: 2025-11-18 15:55:06
Message-ID: CAMon-aSyCvDk924RuP=BU5B4qsFAwJidWzQKmSEMgfL5KXKodQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Duh, I feel silly now :-)

Works perfectly.

Many thanks,

Colin

On Tue, 18 Nov 2025 at 16:11, Greg Sabino Mullane <htamfids(at)gmail(dot)com>
wrote:

> On Tue, Nov 18, 2025 at 4:18 AM Colin 't Hart <colinthart(at)gmail(dot)com>
> wrote:
>
>> alter user <batchuser> set pgaudit.log to 'none';
>>
>
> That's close! pgaudit.log deals with session level things, but you want to
> exclude object-level things. Try:
>
> create role skip_pguadit;
> alter user <batchuser> set pgaudit.role = 'skip_pgaudit';
>
>
> Cheers,
> Greg
>
> --
> Crunchy Data - https://www.crunchydata.com
> Enterprise Postgres Software Products & Tech Support
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2025-11-18 20:23:18 Re: postgres in swap space
Previous Message Greg Sabino Mullane 2025-11-18 15:10:46 Re: Using pgAudit to audit interesting tables for all users except for batch user?