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 по дате отправления:

Предыдущее
От: Ádám Maracska
Дата:
Сообщение: Compile psql 9.6 with SSL Version 1.1.0
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Compile psql 9.6 with SSL Version 1.1.0