From: Ravi Kumar <postgres.query@yahoo.in>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: How to restore backup
Date: Thu, 15 Nov 2012 18:18:22 +0800 (SGT)
Message-ID: <1352974702.81341.YahooMailNeo@web193105.mail.sg3.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgres.query@yahoo.in
Subject: Re: How to restore backup
In-Reply-To: <1352974702.81341.YahooMailNeo@web193105.mail.sg3.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox