Thread: How to restore backup

How to restore backup

From
Ravi Kumar
Date:
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

  can you help me?


with regards
ravi