Re: Proposal: Implement failover on libpq connect level. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal: Implement failover on libpq connect level.
Date
Msg-id 15172.1440007891@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal: Implement failover on libpq connect level.  (Victor Wagner <vitus@wagner.pp.ru>)
List 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 by date:

Previous
From: jacques klein
Date:
Subject: Re: how to write/setup a C trigger function in a background worker
Next
From: Tom Lane
Date:
Subject: Re: proposal: function parse_ident