Re: Advice on logging strategy

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: Advice on logging strategy
Дата
Msg-id 5017eca2-e579-36bb-4878-725878ceaeac@pgmasters.net
обсуждение исходный текст
Ответ на Advice on logging strategy  (Mike Martin <redtux1@gmail.com>)
Ответы Re: Advice on logging strategy
Список pgsql-general
On 10/11/18 11:26 AM, Mike Martin wrote:
> 
> This results in enormous log files which take ages to import using copy 
> becuase each execute statement is logged with the parameters chosen
> 
> Is there any way around this?
> 
> I cant find any way to filter dml statements

pgAudit (https://github.com/pgaudit/pgaudit) gives you fine-grain 
control over what is logged by command type, table, or user as well as a 
lot more detail.

-- 
-David
david@pgmasters.net


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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Want to acquire lock on tables where primary of one table isforeign key on othere
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: RHEL 7 (systemd) reboot