Re: Timeout and wait-forever in sync rep

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Timeout and wait-forever in sync rep
Дата
Msg-id 4CFC95D0.2040506@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Timeout and wait-forever in sync rep  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
On 06.12.2010 07:42, Fujii Masao wrote:
> On Fri, Oct 15, 2010 at 9:41 PM, Fujii Masao<masao.fujii@gmail.com>  wrote:
>> The timeout doesn't oppose to 'wait-forever'. Even if you choose 'wait
>> -forever' (i.e., you set allow_standalone_master to false), the master
>> should detect the standby crash as soon as possible by using the
>> timeout. For example, imagine that max_wal_senders is set to one and
>> the master cannot detect the standby crash because of absence of the
>> timeout. In this case, even if you start new standby, it will not be
>> able to connect to the master since there is no free walsender slot.
>> As the result, the master actually waits forever.
>
> This occurred to me that the timeout would be required even for
> asynchronous streaming replication. So, how about implementing the
> replication timeout feature before synchronous replication itself?

Sounds good to me. The more pieces we can nibble off the main patch the 
better.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: WIP patch for parallel pg_dump
Следующее
От: Fujii Masao
Дата:
Сообщение: Timeout for asynchronous replication Re: Timeout and wait-forever in sync rep