Hi, any idea? can you please advise? On 10 Sep 2013, at 3:22 AM, ascot.m...@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 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 > > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
