Re: PITR Phase 2 - Design Planning
От | Simon Riggs |
---|---|
Тема | Re: PITR Phase 2 - Design Planning |
Дата | |
Msg-id | 1083018000.3018.244.camel@stromboli обсуждение исходный текст |
Ответ на | Re: PITR Phase 2 - Design Planning (Alvaro Herrera <alvherre@dcc.uchile.cl>) |
Ответы |
Re: PITR Phase 2 - Design Planning
|
Список | pgsql-hackers |
On Mon, 2004-04-26 at 23:01, Alvaro Herrera wrote: > 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). You're right, I think we should start by implementing the rollforward to a txnid before we consider the rollforward to a specified point-in-time. All the hooks for that are already there... Best regards, Simon Riggs
В списке pgsql-hackers по дате отправления: