Re: Does the JDBC connection failover require Postgres 10?

On Fri, Nov 3, 2017 at 4:53 AM, Thomas Kellerer <spam_eater(at)gmx(dot)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.