Re: log statements span multiple lines - Mailing list pgsql-novice

From Stuart Kendrick
Subject Re: log statements span multiple lines
Date
Msg-id 4CF2AFB1.5040507@fhcrc.org
Whole thread Raw
In response to Re: log statements span multiple lines  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi Tom,

Ah, I see.  For the moment, I've bumped PG_SYSLOG_LIMIT from 128 to 1024

Thank you,

--sk

On 11/28/2010 8:54 AM, Tom Lane wrote:
> Stuart Kendrick<skendric@fhcrc.org>  writes:
>> How do I tell postmaster to log SQL statements to a single line?
>
> Don't use syslog.
>
>> At the moment, a particular statement gets chopped up across multiple
>> syslog lines:
>
> The reason for this is that many syslog implementations have arbitrary
> limits on line lengths, and will drop or corrupt data beyond that.
>
> If you know what the limit is on your particular platform, you could
> adjust the chopping-point constant in elog.c.  (I would not recommend
> disabling the chopping behavior altogether.)  But on the whole it's
> probably better to switch to another logging method.
>
>             regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: debugging SQL statements
Next
From: Stuart Kendrick
Date:
Subject: Re: debugging SQL statements