Thread: How to restore backup
Dear all ,
when i am trying to restore backup from WAL files ,the following error came:
cannot stat `/opt/pgsqlbackup/wals/00000001.history': No such file or directory
LOG: restored log file "000000010000000000000003" from archive
LOG: unexpected pageaddr 0/A000 in log file 0, segment 3, offset 40960
LOG: invalid primary checkpoint record
LOG: restored log file "000000010000000000000003" from archive
LOG: invalid xl_info in secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 5883) was terminated by signal 6: Aborted
LO:: aborting startup due to startup process failure
LOG: database system was shut down at 2012-11-16 11:56:34 IST
LOG: starting archive recovery
LOG: restored log file "000000010000000000000003" from archive
LOG: unexpected pageaddr 0/A000 in log file 0, segment 3, offset 40960
LOG: invalid primary checkpoint record
LOG: restored log file "000000010000000000000003" from archive
LOG: invalid xl_info in secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 5883) was terminated by signal 6: Aborted
LO:: aborting startup due to startup process failure
LOG: database system was shut down at 2012-11-16 11:56:34 IST
LOG: starting archive recovery
can you help me?
with regards
ravi