Oh sorry for getting the wrong information.
How would I get the information on what driver is currently installed?
On 03/14/2018 09:44 AM, Adrian Klaver wrote:
On 03/14/2018 07:51 AM, chris wrote:
I believe its Postgresql-9.4.1208.jre7.jar
Pretty sure solving this is going to require knowing exactly what
driver is in use. The failover syntax looks to be fairly recent, so
being off by a little on the driver version can make a big difference.
Or you could do as this post suggests:
https://www.postgresql.org/message-id/CADK3HHJgdio_TZ-fpk4rguWaA-wWZFNZrjBft_T4jLBK_E_c8w%40mail.gmail.com
That is install driver version 42.2.1.
On 03/13/2018 05:48 PM, Adrian Klaver wrote:
On 03/13/2018 04:46 PM, chris wrote:
I'm sorry that took a few days but I am running;
Postgresql-9.4
and
jre7.jar
What we are looking for is the JDBC driver you are using?
Thanks in advance.
On 03/08/2018 02:30 PM, chris wrote:
Given that the syntax looks correct for the url, how would we go
about debugging that it's not seeing the comma?
On 03/08/2018 02:27 PM, Adrian Klaver wrote:
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/
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"/
Lets try that again:
To me it looks like whatever code you are using is trying to use
"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'.
Time to clean the glasses:)
It looks like the first IP address has disappeared or is not set
right./
/
Thanks in advance for the help.
//
