| From: | chris <chrisk(at)pgsqlrocket(dot)com> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | JDBC connectivity issue |
| Date: | 2018-03-08 21:12:33 |
| Message-ID: | fde5b685-6820-daa6-de4a-b94d16ba39c5@pgsqlrocket.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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"/
It looks like the first IP address has disappeared or is not set right./
/
Thanks in advance for the help.
//
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-03-08 21:24:59 | Re: JDBC connectivity issue |
| Previous Message | Adrian Klaver | 2018-03-08 21:06:01 | Re: What is the meaning of pg_restore output? |