Re: Standby catch up state change

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Standby catch up state change
Дата
Msg-id 20131015102913.GD5300@awork2.anarazel.de
обсуждение исходный текст
Ответ на Standby catch up state change  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Ответы Re: Standby catch up state change  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Список pgsql-hackers
On 2013-10-15 15:51:46 +0530, Pavan Deolasee wrote:
> Should we not instead wait for the standby to have received all the WAL
> before declaring that it has caught up ? If a failure happens while the
> data is still in the sender's buffer, the standby may not actually catch up
> to the desired point contrary to the LOG message displayed on the master.

I don't think that'd be a good idea - the "caughtup" logic is used to
determine whether we need to wait for further wal to be generated
locally if we haven't got anything else to do. And we only need to do so
when we reached the end of the WAL.

Also, we'd have to reset caughtup everytime we send data (in
XLogSend()), that'd be horrible.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Pavan Deolasee
Дата:
Сообщение: Standby catch up state change
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Re: Standby catch up state change