Duh, I feel silly now :-) Works perfectly.
Many thanks, Colin On Tue, 18 Nov 2025 at 16:11, Greg Sabino Mullane <[email protected]> wrote: > On Tue, Nov 18, 2025 at 4:18 AM Colin 't Hart <[email protected]> > 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 > >
