Re: [Postgres-xc-developers] Connection to Postgres XC cluster from Java

[Michael P. <mic...@gm...>]

On Mon, Jul 8, 2013 at 10:17 AM, 鈴木 幸市 <ko...@in...> wrote:
> Unfortunately, we don't have connection failover.   You may be able to use
> pgboucer for this purpose (sorry, I'm not pgboucer expert) or you may be
> able to use any other connection pooling tools which provides connection
> failover.
Like Postgres, there is no connection failover in XC, you'll need a
third-party software to manage that.

Note that you could use pgbouncer with a dns lookup to combine several
IP addresses that could be used in round-robin manner when
establishing connections. More info:
http://pgbouncer.projects.pgfoundry.org/doc/config.html#_location_parameters

HAProxy is more designed for load balancing and HA, perhaps it's worth
looking at it:
http://haproxy.1wt.eu/#desc
--
Michael