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.
In response to
pgsql-admin by date
|Next:||From: Simon Riggs||Date: 2007-03-30 15:34:51|
|Subject: Re: trying to run PITR recovery|
|Previous:||From: Alvaro Herrera||Date: 2007-03-30 15:04:16|
|Subject: Re: autovacuum question|