Skip site navigation (1) Skip section navigation (2)

Re: trying to run PITR recovery

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Warren Little" <Warren(dot)Little(at)MeridiasCapital(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: trying to run PITR recovery
Date: 2007-03-30 15:31:46
Message-ID: 1175268707.4386.778.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-admin
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



In response to

pgsql-admin by date

Next:From: Simon RiggsDate: 2007-03-30 15:34:51
Subject: Re: trying to run PITR recovery
Previous:From: Alvaro HerreraDate: 2007-03-30 15:04:16
Subject: Re: autovacuum question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group