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

On Tue, Nov 18, 2025 at 4:18 AM Colin 't Hart <colinthart@gmail.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