Re: BUG #13077: when standby crash and restart, it's need next timeline history file, but upstream node normal.

Поиск
Список
Период
Сортировка
От 德哥
Тема Re: BUG #13077: when standby crash and restart, it's need next timeline history file, but upstream node normal.
Дата
Msg-id 5f3591e8.3fe.14ccdd99138.Coremail.digoal@126.com
обсуждение исходный текст
Ответ на Re: BUG #13077: when standby crash and restart, it's need next timeline history file, but upstream node normal.  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
HI, 
Thanks, jeff.
 I find the findNewestTimeLine() do that job. 
 I think this is the NFS problem, standby cann't access the NFS DIR(archive dir), so the copy command hang. 

--
公益是一辈子的事,I'm Digoal,Just Do It.

在 2015-04-19 01:30:31,"Jeff Janes" <jeff.janes@gmail.com> 写道:

On Fri, Apr 17, 2015 at 5:39 PM, 德哥 <digoal@126.com> wrote:
but in my environment, C need the new timeline file, i can see the
restore command display about copy 0000002.history from my setted dir (NFS from remote computer) use top or ps command.
And the copy message display forever.  
ps:
I restart the C compute, and NFS it's ok, recovery it's ok, and don't need the 0000002.history file.

 When postgresql crashed, it need copy new history first whatever it's really need the file?

It needs to know whether the file exists or not.  Rather than asking if the file exists, and then separately asking for a copy of it, instead it just asks for a copy of the file and see if it gets returned an error or not.

If your restore_command hangs up forever when asked for a file that doesn't exist, then there is something wrong with your restore command.

As explained in the documentation, "It is important for the command to return a zero exit status only if it succeeds. The command will be asked for file names that are not present in the archive; it must return nonzero when so asked"
 
Cheers,

Jeff


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #13077: when standby crash and restart, it's need next timeline history file, but upstream node normal.
Следующее
От: puneet252002
Дата:
Сообщение: extension modules missing in Postgresql 9