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

Re: query log corrupted-looking entries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
Cc: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: query log corrupted-looking entries
Date: 2007-06-01 21:36:13
Message-ID: 24195.1180733773@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
"George Pavlov" <gpavlov(at)mynewplace(dot)com> writes:
> On 5/29/2007 10:19 AM, Ed L. wrote:
>> FWIW, I've also been seeing this sort of query log corruption for
>> as long as I can remember, 7.1 through 8.2, HPUX (parisc, ia64),
>> Linux on intel, amd...

What *exactly* is the logging setup you guys use, and have you tried
alternatives?

As best I can tell, the variant with a downstream syslogger process
ought to be OK for messages up to PIPEBUF bytes long on most standard
Unixen.  Of course that's no help if you've got lots of very verbose
queries, but the examples posted so far didn't seem to indicate that.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2007-06-01 21:44:34
Subject: Re: syslogger line-end processing infelicity
Previous:From: Tom LaneDate: 2007-06-01 21:33:31
Subject: Re: syslogger line-end processing infelicity

pgsql-general by date

Next:From: Tyler DurdenDate: 2007-06-01 21:38:12
Subject: Re: Seq Scan
Previous:From: Andrew SullivanDate: 2007-06-01 21:31:20
Subject: Re: Slightly OT.

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