On 03/08/2018 01:12 PM, chris wrote:
Hi,
I have a JDBC temping to connect to 2 postgres nodes in a hot standby
configuration. Running postgres 9.4 on centos6.
What we are trying to accomplish is in an event of a failover, to first
try to connect to the master. If that fails to then reach out to the
standby.
I looked online and found the suggested way to do this, but it's not
working.
This is the JDBC line we have:
/jdbc.url=jdbc:postgresql://10.16.10.12:5432,10.16.10.13:5432/app_db/
That seems to be correct:
https://jdbc.postgresql.org/documentation/94/connect.html
"Connection Fail-over
To support simple connection fail-over it is possible to define multiple
endpoints (host and port pairs) in the connection url separated by
commas. The driver will try to once connect to each of them in order
until the connection succeeds. If none succeed, a normal connection
exception is thrown.
The syntax for the connection url is:
jdbc:postgresql://host1:port1,host2:port2/database"
Here is the error we are getting:/
/
/2018-03-07 13:54:36, 994 ERROR:com.zaxxer.hikari.util.PropertyElf -
failed to set properly port number on target class
org.postgresql.ds.PGSimpleDataSource java.langNumberFormatException:for
input string: "5432,10.16.10.13:5432"/
It looks like the first IP address has disappeared or is not set right./
To me it looks whatever code you are using is trying to us
"5432,10.16.10.13:5432" as the port number for 10.16.10.12. In other
words it is not seeing the ',' as a separator for the two IP's'.
Can you provide more information about the JDBC version you are using
and the app code you are using?
/
Thanks in advance for the help.
//
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
