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

Поиск

Список

Период

Сортировка

От	Greg Sabino Mullane
Тема	Re: Using pgAudit to audit interesting tables for all users except for batch user?
Дата	18 ноября 18:10:46
Msg-id	CAKAnmmLRzMWc8qsKzu7uYoCVTm2fvME3+DqeeXcT6v1JCjiRPw@mail.gmail.com обсуждение исходный текст
Ответ на	Using pgAudit to audit interesting tables for all users except for batch user? ("Colin 't Hart" <colinthart@gmail.com>)
Ответы	Re: Using pgAudit to audit interesting tables for all users except for batch user?
Список	pgsql-general

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

Enterprise Postgres Software Products & Tech Support

В списке pgsql-general по дате отправления: