Re: Point in Time Recovery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Point in Time Recovery
Дата
Msg-id 20120.1089985039@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Point in Time Recovery  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Ответы Re: Point in Time Recovery
Список pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
> We only need to tell people to backup pg_control first. The rest was only 
> intended to enforce 
> 1. that pg_control is the first file backed up
> 2. the dba uses a large enough PIT (or xid) for restore

Right, but I think Bruce's point is that it is far too easy to get those
things wrong; especially point 2 for which a straight tar dump will
simply not contain the information you need to determine what is a safe
stopping point.

I agree with Bruce that we should have some mechanism that doesn't rely
on the DBA to get this right.  Exactly what the mechanism should be is
certainly open for discussion...
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: serverlog rotation/functions
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: [pgsql-hackers-win32] Weird new time zone