Postgres point-in-time recovery failure

From: Cheryl Grant <cheryl(dot)grant(at)aapt(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres point-in-time recovery failure
Date: 2013-02-26 02:00:20
Message-ID: 1361844020330-5746638.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2013-02-26 08:38:12 Re: Postgres point-in-time recovery failure
Previous Message a f 2013-02-26 00:33:55 a f