Re: Lost rows/data corruption?

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Hall" <temp02(at)bluereef(dot)com(dot)au>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, February 15, 2005 3:25 PM
Subject: Re: [GENERAL] Lost rows/data corruption?

> "Andrew Hall" <temp02(at)bluereef(dot)com(dot)au> writes:
>> Here is the data you requested. It took little while to gather it as this
>> kind of corruption doesn't happen all the time.
>
> It sounds like a mess, all right. Do you have a procedure to follow to
> replicate this havoc? Are you sure there's not a hardware problem
> underlying it all?
>
> regards, tom lane
>

We haven't been able to isolate what causes it but it's unlikely to be
hardware as it happens on quite a few of our customer's boxes. We also use
XFS on linux 2.6 as a file system, so the FS should be fairly tolerant to
power-outages. Any ideas as to how I might go about isolating this? Have you
heard any other reports of this kind and suggested remedies?