Skip site navigation (1) Skip section navigation (2)

Re: log statements span multiple lines

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: Stuart KendrickDate: 2010-11-28 19:41:00
Subject: Re: debugging SQL statements
Previous:From: Tom LaneDate: 2010-11-28 16:58:02
Subject: Re: debugging SQL statements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group