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

From Shulgin, Oleksandr
Subject Re: Proposal: Implement failover on libpq connect level.
Date
Msg-id CACACo5QSXo_1mXbnQvQaaSZmN6m5NyhV43Q2ArWRHW_txd74qA@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: Implement failover on libpq connect level.  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
On Fri, Aug 28, 2015 at 6:10 PM, Teodor Sigaev <teodor@sigaev.ru> wrote:
+1 for bringing the jdbc driver URI syntax into libpq, so that all interfaces
can be optionally specified this way. This doesn't preclude the use of
ipfailover, in fact it might be work well together. If you don't like it, don't
use it.

+1

Another thought:  multiple hosts in URI could be used in simple configuration for read-only clients. I faced with customers which manages two connections in process - to master and to one of several slaves.

Hm, but do they suffer any trouble while doing that *outside* of libpq?  What is the benefit in adding this to libpq itself while it already provides very rich and finely grained connection control functions?

--
Alex

pgsql-hackers by date:

Previous
From: "Shulgin, Oleksandr"
Date:
Subject: Re: psql - better support pipe line
Next
From: Andrew Dunstan
Date:
Subject: Re: to_json(NULL) should to return JSON null instead NULL