From: Simon Riggs <simon@2ndquadrant.com>
To: Warren Little <Warren.Little@MeridiasCapital.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: trying to run PITR recovery
Date: Fri, 30 Mar 2007 12:16:34 +0100
Message-ID: <1175253394.4386.745.camel@silverbirch.site> (raw)
In-Reply-To: <63EA6DBE-34B9-4D2D-A61C-D7EF38B3D9DB@MeridiasCapital.com>
References: <63EA6DBE-34B9-4D2D-A61C-D7EF38B3D9DB@MeridiasCapital.com>
On Fri, 2007-03-23 at 17:16 -0600, Warren Little wrote:
> 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.
> I would assume all WAL logs would be restored.
I'm interested in your feedback here. How would you like it to have
acted?
The WAL file was clearly corrupt.
1. Don't continue and don't come up. Have the recovery fail. In order to
bring the server up, we would have to restart recovery with an
additional command to say "I note that my recovery has failed and would
like recovery to come up at the last possible point."
2. Attempt to continue after we fail the CRC check. This is both
dangerous and in many cases won't work either, since this is one of the
normal ending points.
3. Continue after a CRC check, don't attempt to apply the records, just
look at them to determine if they look correct. i.e. see if the CRC
error applies to just that record
4. Add a command to ignore specific WAL records
ignore_record = '11A/FD492B20'
These may also not work very well at all, since many records depend upon
previous data changes, so could quickly end in further errors.
What would you suggest?
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
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: simon@2ndquadrant.com, Warren.Little@MeridiasCapital.com
Subject: Re: trying to run PITR recovery
In-Reply-To: <1175253394.4386.745.camel@silverbirch.site>
* 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