Re: Data Corruption in case of abrupt failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au>
Cc: satish satish <satish_ach2003(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Data Corruption in case of abrupt failure
Date: 2004-03-16 05:56:38
Message-ID: 20893.1079416598@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au> writes:
> On Tue, 2004-03-16 at 16:44, Tom Lane wrote:
>> My money is on IDE drives with write cache enabled.

> I was wondering if he'd turned off fsync(), as seems common for some
> reason...

That would be bad too. But the nasty thing about IDE write caches is
that even when you think you've fsync'd, you haven't :-(

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Keith C. Perry 2004-03-16 07:09:13 Re: Data Corruption in case of abrupt failure
Previous Message Stephen Robert Norris 2004-03-16 05:52:33 Re: Data Corruption in case of abrupt failure