Re: Postgres point-in-time recovery failure

Cheryl Grant wrote:
> 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

That indicates that the WAL file 000000010000017D00000056 is
broken. Are you sure that it is from the PostgreSQL server
you backed up? How did you archive the WAL files?

Yours,
Laurenz Albe