Re: [ADMIN] Postgres point-in-time recovery failure

2013-02-27 Thread Albe Laurenz
Cheryl Grant wrote: >>> 2844LOG: starting point-in-time recovery to 2013-02-26 12:53:00+11 >>> 2844LOG: restored log file "0001017D0056" from archive >>> 2844LOG: unexpected pageaddr 17D/2E00 in log file 381, segment 86, >>> offset 0 >>> 2844LOG: invalid checkpoint recor

Re: [ADMIN] Postgres point-in-time recovery failure

2013-02-26 Thread Cheryl Grant
I'm doing a pg_basebackup to create the instance with -x specified so some of the logs are in the pg_xlog directory after the backup. It always seems to fall over with the same error on the first log. I've tried this numerous times with different backups and it always fails on the first log. I've

Re: [ADMIN] Postgres point-in-time recovery failure

2013-02-26 Thread Albe Laurenz
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 se