Postgres Pro
Downloads
Home   >   mailing lists

Thread: jdbc connection multiple host

jdbc connection multiple host

From
James Pang
Date:
 We plan to migrate Oracle to Postgresql databases. Application put multiple host:ip in connection string, jdbc://host1ip:port,host2:port/dbname , when host1 is accessible, it's preferred. when host1 is not accessible, host2:port is secondary. 
  how to do that through  Postgresql JDBC driver ? 

Thanks,

James

Re: jdbc connection multiple host

From
Padraic Renaghan
Date:

See info here at bottom of this page

From: James Pang jamespang886@gmail.com
Subject: jdbc connection multiple host
Date: 2024-07-30 08:28 EDT

We plan to migrate Oracle to Postgresql databases. Application put
multiple host:ip in connection string,
jdbc://host1ip:port,host2:port/dbname , when host1 is accessible, it's
preferred. when host1 is not accessible, host2:port is secondary.
how to do that through Postgresql JDBC driver ?

Thanks,

James