Hi, any idea? can you please advise?
On 10 Sep 2013, at 3:22 AM, ascot.moss@gmail.com wrote:
> Hi,
>
> For special testing reason, I am trying to restore PG from a backup that the basebase is from Standby and WAL files
arefrom Master. During recovery phase, for every WAL file process, it returned 'invalid resource manager ID in primary
checkpointrecord' and paused, I had to manually run "$PGBIN/pg_resetxlog -f $PG_DATA" many times, is there a way to set
PGto 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
>
>
>
>