Re: PITR Phase 2 - Design Planning

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: PITR Phase 2 - Design Planning
Дата
Msg-id 20040426220128.GC27578@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: PITR Phase 2 - Design Planning  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: PITR Phase 2 - Design Planning  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
On Mon, Apr 26, 2004 at 05:05:41PM -0400, Bruce Momjian wrote:
> Simon Riggs wrote:
> > Transaction log files currently have timestamps, so that is
> > straightforward, but probably not the best we can do. We would
> > rollforward until the xlog file time > desired point in time.
> 
> I was thinking ---  how would someone know the time to use for restore?

I think there should be a way to get a TransactionId and restore up to
that point.  It'd be cool, but not required, if the system showed what
valid TransactionIds there are, and roughly what they did (the xlog
code already has "describers" everywhere AFAICS).

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El realista sabe lo que quiere; el idealista quiere lo que sabe" (Anónimo)


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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: FW: getting a crash during initdb
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Usability, MySQL, Postgresql.org, gborg, contrib, etc.