From: Cheryl Grant <cheryl.grant@aapt.com.au>
To: pgsql-admin@postgresql.org
Subject: Postgres point-in-time recovery failure
Date: Mon, 25 Feb 2013 18:00:20 -0800 (PST)
Message-ID: <1361844020330-5746638.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi, I'm trying to test restoration of a database using point-in-time
recovery. I'm taking a backup of the database using pg_basebackup:
pg_basebackup -D /postgres/data -Fp -l RestorePostgres -U reco -w -h
radmast01 -p 5432
Then attempting to recover the backup on a second server using the following
recovery.conf settings:
restore_command = 'cp /apps/postgres/backup/WAL/%f %p'
recovery_target_time = '2013-02-26 12:53:00'
recovery_target_inclusive=true
Every time I start the recovery I get the following error in the log file
and the instance crashes:
2844LOG: database system was interrupted; last known up at 2013-02-26
12:46:56 EST
2844LOG: creating missing WAL directory "pg_xlog/archive_status"
2844LOG: starting point-in-time recovery to 2013-02-26 12:53:00+11
2844LOG: restored log file "000000010000017D00000056" from archive
2844LOG: unexpected pageaddr 17D/2E000000 in log file 381, segment 86,
offset 0
2844LOG: invalid checkpoint record
2844FATAL: could not locate required checkpoint record
2844HINT: If you are not restoring from a backup, try removing the file
"/apps/postgres/data/backup_label".
2825LOG: startup process (PID 2844) exited with exit code 1
2825LOG: aborting startup due to startup process failure
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Postgres-point-in-time-recovery-failure-tp5746638.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: cheryl.grant@aapt.com.au
Subject: Re: Postgres point-in-time recovery failure
In-Reply-To: <1361844020330-5746638.post@n5.nabble.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