invalid resource manager ID in primary checkpoint record

Поиск
Список
Период
Сортировка
От ascot.moss@gmail.com
Тема invalid resource manager ID in primary checkpoint record
Дата
Msg-id 0A3270AA-31DC-4BA7-BC74-11BCAF38F80E@gmail.com
обсуждение исходный текст
Ответ на Re: Making substrings uppercase  (David Johnston <polobo@yahoo.com>)
Ответы Re: invalid resource manager ID in primary checkpoint record
fsync and wal_sync_method
Список 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
fromMaster.  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






В списке pgsql-general по дате отправления:

Предыдущее
От: Quentin Hartman
Дата:
Сообщение: Re: Call for design: PostgreSQL mugs
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Call for design: PostgreSQL mugs