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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
