invalid resource manager ID in primary checkpoint record

From: "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com>
To: pgsql-general general <pgsql-general(at)postgresql(dot)org>
Cc: ascot(dot)moss(at)gmail(dot)com
Subject: invalid resource manager ID in primary checkpoint record
Date: 2013-09-09 19:22:21
Message-ID: 0A3270AA-31DC-4BA7-BC74-11BCAF38F80E@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

For special testing reason, I am trying to restore PG from a backup that the basebase is from Standby and WAL files are from Master. During recovery phase, for every WAL file process, it returned 'invalid resource manager ID in primary checkpoint record' and paused, I had to manually run "$PGBIN/pg_resetxlog -f $PG_DATA" many times, is there a way to set PG to ignore this kind of errors.

LOG: database system was shut down at 2013-09-10 03:06:29 : starting archive recovery
LOG: restored log file "00000001000000B9000000CA" from archive
LOG: invalid resource manager ID in primary checkpoint record
LOG: invalid secondary checkpoint link in control file
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 17969) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
.
LOG: restored log file "00000001000000B9000000CB" from archive
LOG: invalid resource manager ID in primary checkpoint record
LOG: invalid secondary checkpoint link in control file
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 17981) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
.
LOG: restored log file "00000001000000B9000000CC" from archive
.
LOG: restored log file "00000001000000B9000000CD" from archive

Please advise.
regards

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2013-09-09 20:02:17 Re: Call for design: PostgreSQL mugs
Previous Message Quentin Hartman 2013-09-09 17:25:59 Re: Call for design: PostgreSQL mugs