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 по дате отправления: