Re: Postgres point-in-time recovery failure

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Postgres point-in-time recovery failure
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B057B884A@ntex2010a.host.magwien.gv.at
обсуждение исходный текст
Ответ на Postgres point-in-time recovery failure  (Cheryl Grant <cheryl.grant@aapt.com.au>)
Ответы Re: Postgres point-in-time recovery failure  (Cheryl Grant <cheryl.grant@aapt.com.au>)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Cheryl Grant
Дата:
Сообщение: Postgres point-in-time recovery failure
Следующее
От: Cheryl Grant
Дата:
Сообщение: Re: Postgres point-in-time recovery failure