Re: log statements span multiple lines

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(at)fhcrc(dot)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