Re: Advice on logging strategy

Поиск
Список
Период
Сортировка
От Mike Martin
Тема Re: Advice on logging strategy
Дата
Msg-id CAOwYNKajjAvJ=MvJm5dDcKrLhiXMYTg8QYjo5hX=w8tFMbFZ4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Advice on logging strategy  (David Steele <david@pgmasters.net>)
Список pgsql-general
Thanks!

On Fri, 12 Oct 2018 at 14:33, David Steele <david@pgmasters.net> wrote:
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 по дате отправления: