How to restore backup - Mailing list pgsql-admin

From Ravi Kumar
Subject How to restore backup
Date
Msg-id 1352974702.81341.YahooMailNeo@web193105.mail.sg3.yahoo.com
Whole thread Raw
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Query Stuck in running server
Next
From: Craig James
Date:
Subject: Re: Failed Login Attempts parameter