Re: Assembling "top features" list for beta announcement

From: Michael Banck <michael(dot)banck(at)credativ(dot)de>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: Josh Berkus <josh(at)berkus(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Assembling "top features" list for beta announcement
Date: 2017-04-10 19:25:02
Message-ID: 1491852302.25270.65.camel@credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Am Montag, den 10.04.2017, 11:42 -0400 schrieb Peter Eisentraut:
> On 4/8/17 04:50, Michael Banck wrote:
> > "Client-Side Connection-Failover"
>
> I don't think the libpq feature can be considered "failover".

Hrm.

> It just picks from a list of end points on the initial connection
> attempt.

Right.

> It does not discover connection failures and reconnect.

Does any other 3rd party tooling for Postgres do that? I assume the
client will get the connection failure and, upon reconnection, will get
a good new connection, essentially failing over to the next host. Oracle
has "Transparent Application Failover", but that's a pretty high bar I
am not sure anybody is expecting us to jump over just now.

I phrased it "connection-based client-side failover" in another mail,
would emphasizing that it is at connection granularity be enough to
address your concerns? The pgJDBC called the (AFAICT) identical feature
"connection failover" in their changelogs for 9.3-1100 and 9.4-1200:

https://jdbc.postgresql.org/documentation/changelog.html#version_9.3-1100
https://jdbc.postgresql.org/documentation/changelog.html#version_9.4-1200

Michael

--
Michael Banck
Projektleiter / Senior Berater
Tel.: +49 2166 9901-171
Fax: +49 2166 9901-100
Email: michael(dot)banck(at)credativ(dot)de

credativ GmbH, HRB Mönchengladbach 12080
USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Josh Berkus 2017-04-11 15:49:12 Re: Assembling "top features" list for beta announcement
Previous Message Joshua D. Drake 2017-04-10 19:23:29 Re: Assembling "top features" list for beta announcement