On Tue, 15 Feb 2005, Andrew Hall wrote:
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?
Are you running with fsync = off? and did the hosts experience any power-outage recently?
.TM. -- ____/ ____/ / / / / Marco Colombo ___/ ___ / / Technical Manager / / / ESI s.r.l. _____/ _____/ _/ [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org