Re: Does the JDBC connection failover require Postgres 10?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Does the JDBC connection failover require Postgres 10?
Date: 2017-11-03 16:59:30
Message-ID: oti79d$ivs$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

David G. Johnston schrieb am 03.11.2017 um 15:19:
> On Fri, Nov 3, 2017 at 4:53 AM, Thomas Kellerer <spam_eater(at)gmx(dot)net <mailto: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.

Thanks, apparently I mis-read the release notes

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2017-11-06 00:36:16 Re: Statement-level rollback
Previous Message David G. Johnston 2017-11-03 14:19:39 Re: Does the JDBC connection failover require Postgres 10?