To: "Andrew Hall" <temp02@xxxxxxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, February 15, 2005 3:25 PM
Subject: Re: Lost rows/data corruption?
"Andrew Hall" <temp02@xxxxxxxxxxxxxxx> 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?
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
