Re: trying to run PITR recovery

On Fri, 2007-03-30 at 08:23 -0600, Warren Little wrote:

> On slightly different topic, is there some way to determine the
> timeline of the corrupted segment, ie what was the original time of
> the last restored transaction.

You need to examine the WAL files using xlogdump available from
pgfoundry.org - its not part of the main distribution yet.

Reporting the time of the last commit/abort record seen in the WAL seems
like an easy and useful addition to make.

e.g. LOG: last transaction originally completed at 2007-02-23 05:57:35

Point-in-time recovery really ought to tell you the point-in-time it has
stopped at sounds blindingly obvious in retrospect.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com