Re: Proposal: Implement failover on libpq connect level.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposal: Implement failover on libpq connect level.
Дата
Msg-id 15172.1440007891@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposal: Implement failover on libpq connect level.  (Victor Wagner <vitus@wagner.pp.ru>)
Список pgsql-hackers
Victor Wagner <vitus@wagner.pp.ru> writes:
> On 2015.08.20 at 00:17:35 +0900, Tatsuo Ishii wrote:
>> One downside of this is, if one of the standby servers is not
>> responding, every time clients will be blocked by the server before
>> giving up the connection trial. This could last for hours (for

> This shouldn't happen. My proposal was to connect all servers
> simultaneously, and then use that connection which would be established
> first closing other ones

That seems like seriously unfriendly behavior.  It will trigger dropped
connection bleats in the server logs, not to mentioned wasted process
forks.
        regards, tom lane



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

Предыдущее
От: jacques klein
Дата:
Сообщение: Re: how to write/setup a C trigger function in a background worker
Следующее
От: Tom Lane
Дата:
Сообщение: Re: proposal: function parse_ident