Re: Install Postgres on a SAN volume? - Mailing list pgsql-general

From Greg Smith
Subject Re: Install Postgres on a SAN volume?
Date
Msg-id Pine.GSO.4.64.0809090404070.572@westnet.com
Whole thread Raw
In response to Re: Install Postgres on a SAN volume?  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Install Postgres on a SAN volume?
List pgsql-general
On Tue, 9 Sep 2008, Magnus Hagander wrote:

> As long as your SAN guarantees an atomic snapshot of all your data
> (which every SAN I've ever heard of guarantees if you're on a single
> volume - entry level SANs often don't have the functionality to do
> multi-volume atomic snapshots, though), you don't need to set up PITR
> for simple backups

It's all those ifs in there that leave me still recommending it.  It's
certainly possible to get a consistant snapshot with the right hardware
and setup.  What concerns me about recommending that without a long list
of caveats is the kinds of corruption you'd get if all those conditions
aren't perfect will of course not ever happen during testing.  Murphy says
that it will happen only when you find yourself really needing that
snapshot to work one day.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: Re: 8.3 on FreeBSD 6.3, sudden performance degradations
Next
From: Greg Smith
Date:
Subject: Re: 8.3 on FreeBSD 6.3, sudden performance degradations