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

From Tom Lane
Subject Re: log statements span multiple lines
Date
Msg-id 22234.1290963275@sss.pgh.pa.us
Whole thread Raw
In response to log statements span multiple lines  (Stuart Kendrick <skendric@fhcrc.org>)
Responses Re: log statements span multiple lines  (Stuart Kendrick <skendric@fhcrc.org>)
List pgsql-novice
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: Stuart Kendrick
Date:
Subject: debugging SQL statements
Next
From: Tom Lane
Date:
Subject: Re: debugging SQL statements