Re: VMWare file system / database corruption - Mailing list pgsql-general

From Scott Marlowe
Subject Re: VMWare file system / database corruption
Date
Msg-id dcc563d10909211101q13d32257nb4be0c9d205d8945@mail.gmail.com
Whole thread Raw
In response to Re: VMWare file system / database corruption  (Vick Khera <vivek@khera.org>)
List pgsql-general
On Mon, Sep 21, 2009 at 11:53 AM, Vick Khera <vivek@khera.org> wrote:
> On Mon, Sep 21, 2009 at 1:40 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>>  Even if properly setup NFS is a problem waiting to
>> happen, and it's not reliable storage for a database in my opinion.
>
>
> It reads to me that the VMware image is pulled from NFS, so as far as
> Pg is concerned, it is speaking to a local disk. Whether that disk is
> properly backed to disk is an open question.  I don't know what kind
> of durability guarantee postgres can give you if the VM itself is
> read/written over a known not-100% reliable file system.

Oh, I completely read that wrong then.

> That is, does the sync() call inside the VM not return until the
> underlying VM image data is on actual hard platters? I doubt it.

I'm pretty sure fsync is properly supported in VMWare by default, but
there are settings to turn it off.  Could be the other way around.
Either way, this isn't really the best place probably to get VMWare
support.

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: VMWare file system / database corruption
Next
From: Alex Gadea
Date:
Subject: Re: VMWare file system / database corruption