Simon Riggs wrote: > 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...
Yep, sounds like a plan. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
