Re: PITR Backups

Поиск
Список
Период
Сортировка
От Dan Gorman
Тема Re: PITR Backups
Дата
Msg-id 0099C2EC-E872-44E3-BA0A-64D58DFDFE5F@hi5.com
обсуждение исходный текст
Ответ на Re: PITR Backups  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
It's the latter, is snapshot of the durable state of the storage
system (e.g. it will never be corrupted)

Regards,
Dan Gorman

On Jun 22, 2007, at 11:02 AM, Tom Lane wrote:

> "Simon Riggs" <simon@2ndquadrant.com> writes:
>> On Fri, 2007-06-22 at 13:12 -0400, Tom Lane wrote:
>>> If you saw a problem I'd be inclined to question whether
>>> there is some upstream component (OS or disk controller) that's
>>> reordering writes.
>
>> Given thats exactly what they do, constantly, I don't think its
>> safe to
>> say that it works since we cannot verify whether that has happened or
>> not.
>
> If he's trying to snapshot at a level of hardware that's behind a
> write-caching disk controller, I agree that that's untrustworthy.
>
> If not, ie if he's snapshotting the actual durable state of the
> storage
> system, then any problems in the snapshot indicate a problem with the
> database's ability to recover from a crash.  So I don't think you
> should
> tell him to not worry.
>
>             regards, tom lane



В списке pgsql-performance по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: PITR Backups
Следующее
От: Dan Gorman
Дата:
Сообщение: Re: PITR Backups