pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Warren Little <Warren.Little@MeridiasCapital.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: trying to run PITR recovery
Date: Sun, 25 Mar 2007 20:57:47 -0400
Message-ID: <1625.1174870667@sss.pgh.pa.us> (raw)
In-Reply-To: <63EA6DBE-34B9-4D2D-A61C-D7EF38B3D9DB@MeridiasCapital.com>
References: <63EA6DBE-34B9-4D2D-A61C-D7EF38B3D9DB@MeridiasCapital.com>

Warren Little <Warren.Little@MeridiasCapital.com> writes:
> I'm testing my PITR recovery procedures and something doesn't look  
> right.
> The following is from the logs upon starting postgres with  
> recovery.conf file in place

> @ 2007-03-23 05:57:33 MDTLOG:  restored log file  
> "000000010000011A000000FD" from archive
> @ 2007-03-23 05:57:35 MDTLOG:  incorrect resource manager data  
> checksum in record at 11A/FD492B20
> @ 2007-03-23 05:57:35 MDTLOG:  redo done at 11A/FD492210

> My concern is that there were many more logfiles to be played  
> following "00000010000011A000000FD"
> (ie 000000010000011E0000005C) yet it appears the recovery stop at  
> that point and called it good.

Perhaps you have a bad copy of that particular log segment file?
The "incorrect checksum" failure is normal in certain circumstances
(eg, where the system crashes partway through writing out a large
WAL record), which is why the code treats it as indicating the end
of WAL.  But in this case it looks more like corrupt data ...

			regards, tom lane



view thread (8+ messages)  latest in thread

Message-ID: <1625.1174870667@sss.pgh.pa.us>
Permalink:  ../1625.1174870667@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1625.1174870667@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, Warren.Little@MeridiasCapital.com
  Subject: Re: trying to run PITR recovery
  In-Reply-To: <1625.1174870667@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox