Date: Mon, 25 Feb 2013 18:00:20 -0800 (PST)
From: Cheryl Grant <cheryl.grant@aapt.com.au>
To: pgsql-admin@postgresql.org
Message-ID: <1361844020330-5746638.post@n5.nabble.com>
Subject: Postgres point-in-time recovery failure
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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