Re: PITR Phase 2 - Design Planning - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: PITR Phase 2 - Design Planning
Date
Msg-id 20040426220128.GC27578@dcc.uchile.cl
Whole thread Raw
In response to Re: PITR Phase 2 - Design Planning  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: PITR Phase 2 - Design Planning  (Simon Riggs <simon@2ndquadrant.com>)
List 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 by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: FW: getting a crash during initdb
Next
From: Josh Berkus
Date:
Subject: Re: Usability, MySQL, Postgresql.org, gborg, contrib, etc.