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

From Scott Marlowe
Subject Re: VMWare file system / database corruption
Date
Msg-id dcc563d10909211040t653f806ao9edc284382959288@mail.gmail.com
Whole thread Raw
In response to VMWare file system / database corruption  (Tom Duffey <tduffey@techbydesign.com>)
Responses Re: VMWare file system / database corruption  (Vick Khera <vivek@khera.org>)
Re: VMWare file system / database corruption  (Alex Gadea <alex.gadea@apptik.com>)
Re: VMWare file system / database corruption  (Tom Duffey <tduffey@techbydesign.com>)
List pgsql-general
On Mon, Sep 21, 2009 at 11:09 AM, Tom Duffey <tduffey@techbydesign.com> wrote:
> Hi All,
>
> We're having numerous problems with a PostgreSQL 8.3.7 database running on a
> virtual Linux server w/VMWare ESX.  This is not by choice and I have been
> asking the operator of this equipment for details about the disk setup and
> here's what I got:
>
> "We have a SAN that is presenting an NFS share.  VMWare sees that share and
> reads the VMDK file that make up the virtual file system."
>
> Does anyone with a better understanding of PostgreSQL and VMWare know if
> this is an unreliable setup for PostgreSQL?  I see things like "NFS" and
> "VMWare" and start to get worried.

I see VMWare and thing performance issues, I see NFS and thing dear
god help us all.  Even if properly setup NFS is a problem waiting to
happen, and it's not reliable storage for a database in my opinion.
That said, lots of folks do it.  Ask for the NFS mount options from
the sysadmin.

pgsql-general by date:

Previous
From: Tom Duffey
Date:
Subject: VMWare file system / database corruption
Next
From: Scott Marlowe
Date:
Subject: Re: Storage of Foreign Keys