Re: Duplicate primary keys/rows

On Mon, 2005-10-10 at 15:51, CSN wrote:
> I don't have a compiler on this machine. If somebody
> can point me to a copy of pg_filedump for Windows (I
> didn't see any using Google) I'd be happy to use it.
> Or perhaps I could compile it under cygwin.
>
> The hard drive is a Western Digital 200GB JD (SATA),
> if that can be used to determine how badly it lies. ;)

The general rule is that ATA (parallel or serial) drives lie.  You can
turn off the write cache, which will make it slower, but then it should
be reliable during a power loss.

Or, put it all on a big UPS and hope the power supply never goes out.