| From: | Mikko Tiihonen <Mikko(dot)Tiihonen(at)nitorcreations(dot)com> |
|---|---|
| To: | kaprikorn07 <bharath(dot)spyk(at)gmail(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Failover Datasource? |
| Date: | 2012-12-12 10:41:08 |
| Message-ID: | 51061EFB789B4A45AC6598C83649B7BE9B687C10@NBL-EXCD1-01.nebula.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
With latest jdbc drivers you can simply configure multiple host:port pairs in the url separated by comma:
jdbc:postgresql://host1:port1,host2:port2/test
It has only the most basic failover support. When a new connection is opened the hosts are tried in round-robin until a connection is successfully established.
-Mikko
________________________________________
From: pgsql-jdbc-owner(at)postgresql(dot)org [pgsql-jdbc-owner(at)postgresql(dot)org] on behalf of kaprikorn07 [bharath(dot)spyk(at)gmail(dot)com]
Sent: 12 December 2012 11:09
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Failover Datasource?
Hi All,
As Bruce Adams has mentioned, please let me know if there is any other way
to do it other than pgBouncer and pgPool.
Please help!
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Re-Failover-Datasource-tp4496411p5736270.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2012-12-12 10:49:39 | Re: Failover Datasource? |
| Previous Message | kaprikorn07 | 2012-12-12 09:09:00 | Re: Failover Datasource? |