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