Re: Too much logging - Mailing list pgsql-general

From Mike Christensen
Subject Re: Too much logging
Date
Msg-id AANLkTinGN12AsO-qkOf4NiVw-zuT44qYBGdNs-VaWNNS@mail.gmail.com
Whole thread Raw
In response to Re: Too much logging  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Yup, someone emailed me privately - this fixed the problem..  Thanks!

On Fri, Aug 27, 2010 at 2:55 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
> Mike Christensen, 27.08.2010 11:39:
>>
>> Hi all -
>>
>> I've noticed my log files for Postgres are getting way too big, since
>> every single SQL statement being run ends up in the log.  However,
>> nothing I change in postgresql.conf seems to make a bit of
>> difference..  I've tried restarting postgres, deleting all the
>> existing logs, etc.  No matter what I do, every statement is logged.
>>
>> What I want is to only log SQL statements that result in errors.
>> Here's my config options:
>>
>> log_destination = 'stderr'
>> logging_collector = on
>> client_min_messages = error
>> log_min_messages = error
>> log_error_verbosity = default
>> log_min_error_statement = error
>> log_min_duration_statement = 3000
>> log_statement = 'all'
>>
>> Pretty much everything else log related is commented out..  What am I
>> doing wrong?  Thanks!
>
>
> log_statement = 'all'
>
> should be
>
> log_statement = 'none'
>
> Regards
> Thomas
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Too much logging
Next
From: Richard Harley
Date:
Subject: Re: Is your data okay?