JDBC connectivity issue

chris <chrisk@xxxxxxxxxxxxxxx> · Thu, 8 Mar 2018 14:12:33 -0700



    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="">

    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.

      
    Thanks in advance for the help.