I'd be careful using VMWARE as a database server for anything other than production. I've had problems with SQL Server
andmySQL databases and I am sure that Postgres will experience problems as well.
One thing to look at is whether snapshots are set to be taken while the database is active. If they are, ask the
systemadmin to find another way to make backups of the VM. My experience has been that snapshots cause many problems
withdatabases.
Alex
----- Original Message -----
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Tom Duffey" <tduffey@techbydesign.com>
Cc: pgsql-general@postgresql.org
Sent: Monday, September 21, 2009 1:40:33 PM GMT -05:00 US/Canada Eastern
Subject: Re: [GENERAL] VMWare file system / database corruption
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general