Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 05CAE9FC802 for ; Fri, 1 Jun 2007 18:36:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 43582-02 for ; Fri, 1 Jun 2007 18:36:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 589559FC7DE for ; Fri, 1 Jun 2007 18:36:38 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l51LaD65024196; Fri, 1 Jun 2007 17:36:13 -0400 (EDT) To: "George Pavlov" cc: "Ed L." , pgsql-general@postgresql.org Subject: Re: query log corrupted-looking entries In-reply-to: <8C5B026B51B6854CBE88121DBF097A86CDD9A4@ehost010-33.exch010.intermedia.net> References: <29860.1161202644@sss.pgh.pa.us> <8C5B026B51B6854CBE88121DBF097A86C39FC2@ehost010-33.exch010.intermedia.net> <200705291119.55567.pgsql@bluepolka.net> <8C5B026B51B6854CBE88121DBF097A86CDD9A4@ehost010-33.exch010.intermedia.net> Comments: In-reply-to "George Pavlov" message dated "Fri, 01 Jun 2007 14:09:04 -0700" Date: Fri, 01 Jun 2007 17:36:13 -0400 Message-ID: <24195.1180733773@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/140 X-Sequence-Number: 114963 "George Pavlov" 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