Unable to recovery due missing wal_file

Поиск
Список
Период
Сортировка
От Patrick B
Тема Unable to recovery due missing wal_file
Дата
Msg-id CAJNY3itSh-6HC5JWq1wPqEjMFy2Tksh2hR9-mKt2Q=9RL-ix=A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Unable to recovery due missing wal_file  (Patrick B <patrickbakerbr@gmail.com>)
Re: Unable to recovery due missing wal_file  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi guys,

I'm currently using PostgreSQL 9.2.

One of my backup servers went down, and I had to re-sync the all the DB.
I used pg_basebackup and, of course, at the same time wal_archive.

Steps:

1 - Confirm the wal_files are being copied into the new server.
2 - Delete /var/lib/pgsql/9.2/data/*
3 - Double check the wal_files are ok into the server
4 - Start pg_basebackup
5 - pg_basebackup took 10 days, as our DB is 2.0TB.
6 - Start postgres with the recovery.conf.restore_comand
7 - Wait for the wal_files being processed

I got an error here: 00000002000013B40000001A` not found
How is that possible? If I double checked!! :(
I can't find that file anywhere.. and now I'll have to re-do all the work =(

Is there any tips you guys could give me on this situation?

Should I check the backup_label file when the pg_basebackup starts, and check if the wal_file inside the backup_label file exists?

Thanks
Patrick
 

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: 9.3 to 9.5 upgrade problems
Следующее
От: Patrick B
Дата:
Сообщение: Re: Unable to recovery due missing wal_file