Re: query log corrupted-looking entries - Mailing list pgsql-general

From George Pavlov
Subject Re: query log corrupted-looking entries
Date
Msg-id 8C5B026B51B6854CBE88121DBF097A86CDD9A4@ehost010-33.exch010.intermedia.net
Whole thread Raw
In response to Re: query log corrupted-looking entries  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: query log corrupted-looking entries  ("Ed L." <pgsql@bluepolka.net>)
Re: query log corrupted-looking entries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 5/29/2007 10:19 AM, Ed L. wrote:
> On Wednesday 23 May 2007 1:04 pm, George Pavlov 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...

Do you have any tricks for dealing with the problem from a query
analyzer perspective? That is, if you use something like pgfouine do you
have any quick and easy way to remove those lines (and the affected
lines around them)? Or someway to "fix" the corrupted lines? I'd say
that lately ~40% of my daily query logs are suffering from this problem
making query analysis very hard.

George

pgsql-general by date:

Previous
From: "Ian Harding"
Date:
Subject: Re: collision in serial numbers after INSERT?
Next
From: Ron Johnson
Date:
Subject: Re: why postgresql over other RDBMS