Re: Recovery problem with PostgreSQL

Поиск
Список
Период
Сортировка
От Shoaib Mir
Тема Re: Recovery problem with PostgreSQL
Дата
Msg-id bf54be870605110756vb733314x1b0acae0eba1cc63@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recovery problem with PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
That should be true about `/data1_node5/arch/00000001.history'  since there may not be any timelines created by previous archiver recoveries

But the message

cp: cannot stat  `/data1_node5/arch/000000010000000000000007''

suggests that it was not able to restore one of the log files while doing the recovery So it can be treated as an error I guess due to missing log file in the archive folder. That might be due to the archive command not setup correctly and as a result it was not able to copy files from pg_xlog to archive folder.

/Shoaib

On 5/11/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Shoaib Mir" <shoaibmir@gmail.com> writes:
> While running the recovery process I am getting the following errors for
> cannot stat:

> cp: cannot stat `/data1_node5/arch/00000001.history': No such file or
> directory

What makes you think this is an error?  As pointed out in the docs,
the archive_recovery command *will* be asked for files that don't
exist.  You might want to tweak your script to not report an error
in this case.

                        regards, tom lane

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

Предыдущее
От: Tony Caduto
Дата:
Сообщение: Re: Debugging SQL queries
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Debugging SQL queries