From: | Stuart Kendrick <skendric(at)fhcrc(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: log statements span multiple lines |
Date: | 2010-11-28 19:38:25 |
Message-ID: | 4CF2AFB1.5040507@fhcrc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Kendrick | 2010-11-28 19:41:00 | Re: debugging SQL statements |
Previous Message | Tom Lane | 2010-11-28 16:58:02 | Re: debugging SQL statements |