Re: Failing start-up archive recovery at Standby mode in PG9.2.4

Поиск
Список
Период
Сортировка
От Kyotaro HORIGUCHI
Тема Re: Failing start-up archive recovery at Standby mode in PG9.2.4
Дата
Msg-id CAM103DvJHSBYdFwhy6f4jmHvg9AGhxCunzeYGikcfekPAGqp3g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Failing start-up archive recovery at Standby mode in PG9.2.4  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: Failing start-up archive recovery at Standby mode in PG9.2.4  (Kyotaro HORIGUCHI <kyota.horiguchi@gmail.com>)
Re: Failing start-up archive recovery at Standby mode in PG9.2.4  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Hello,

> > cp: cannot stat `../arc/000000030000000000000013': そのようなファイルやディレクトリはありません
> > [Standby] 2013-04-22 01:27:25 EDTLOG:  00000: restored log file "000000020000000000000013" from archive

> I can't read the error message here, but this looks suspicious.

The error message is "No such file or directory" in Japanese :-).
Perhaps restore_command is 'cp ../arc/%f %p'.

> The recovery command seems to be returning success although it prints such
an error message?

It seems that, on 9.2.4, RestoreArchivedFile returns expected xlog
filename even if the restore command ends up in failure. And the
caller XLogFileOpen successfully ets and returns fd for the filename
if the file exists since before the restoration attempt. It does not
matter when the existing file and the file expected to be restored are
identical in content.

If the segment includes the timeline increment point, something might
happen, I suppose..

regards,

-- 
Kyotaro Horiguchi



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Fast promotion, loose ends
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Failing start-up archive recovery at Standby mode in PG9.2.4