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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
