Re: Advice on logging strategy - Mailing list pgsql-general

From Mike Martin
Subject Re: Advice on logging strategy
Date
Msg-id CAOwYNKajjAvJ=MvJm5dDcKrLhiXMYTg8QYjo5hX=w8tFMbFZ4Q@mail.gmail.com
Whole thread Raw
In response to Re: Advice on logging strategy  (David Steele <david@pgmasters.net>)
List 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 by date:

Previous
From: Ádám Maracska
Date:
Subject: Compile psql 9.6 with SSL Version 1.1.0
Next
From: Adrian Klaver
Date:
Subject: Re: Compile psql 9.6 with SSL Version 1.1.0