Postgres Pro
Downloads
Home   >   mailing lists

Re: [JDBC] Does the JDBC connection failover require Postgres 10? - Mailing list pgsql-jdbc

From David G. Johnston
Subject Re: [JDBC] Does the JDBC connection failover require Postgres 10?
Date
Msg-id CAKFQuwZPcmJxtzHnebGZMT0APfxfxt69GWSG2HmxtQOmAiazgA@mail.gmail.com
Whole thread Raw
In response to [JDBC] Does the JDBC connection failover require Postgres 10?  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: [JDBC] Does the JDBC connection failover require Postgres 10?  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-jdbc
Tree view
On Fri, Nov 3, 2017 at 4:53 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
The Postgres JDBC driver offers a way to specify multiple hosts in the connection URL:

   https://jdbc.postgresql.org/documentation/head/connect.html#connection-failover

However, it is unclear to me if that feature relies on the libpq feature introduced in Postgres 10:

   https://www.postgresql.org/docs/current/static/libpq-connect.html#libpq-multiple-hosts

or if this is handled by the driver internally?

​In short, it is handled by the driver internally.​

There is no server support (which make sense given failure to connect would preclude the presence of a server) in the libpq implementation of this behavior - i.e., its not a protocol thing but a client implementation.  The JDBC driver does not utilize libpq at all, it directly implements the PostgreSQL communication protocol.

David J.

pgsql-jdbc by date:

Previous
From: Jorge Solórzano
Date:
Subject: Re: [JDBC] Does the JDBC connection failover require Postgres 10?
Next
From: Thomas Kellerer
Date:
Subject: Re: [JDBC] Does the JDBC connection failover require Postgres 10?