Re: Install Postgres on a SAN volume?

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Install Postgres on a SAN volume?
Дата
Msg-id Pine.GSO.4.64.0809090404070.572@westnet.com
обсуждение исходный текст
Ответ на Re: Install Postgres on a SAN volume?  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Install Postgres on a SAN volume?  (Magnus Hagander <magnus@hagander.net>)
Список 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 по дате отправления:

Предыдущее
От: Tomasz Ostrowski
Дата:
Сообщение: Re: 8.3 on FreeBSD 6.3, sudden performance degradations
Следующее
От: Greg Smith
Дата:
Сообщение: Re: 8.3 on FreeBSD 6.3, sudden performance degradations