Re: Proposal: Implement failover on libpq connect level. - Mailing list pgsql-hackers

From PostgreSQL - Hans-Jürgen Schönig
Subject Re: Proposal: Implement failover on libpq connect level.
Date
Msg-id 64ED0EEC-49B3-404F-839E-6C0EE5554AFE@cybertec.at
Whole thread Raw
In response to Re: Proposal: Implement failover on libpq connect level.  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: Proposal: Implement failover on libpq connect level.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
> On 18 Aug 2015, at 11:19, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
>
> Hans-Jürgen Schönig wrote:
>> in addition to that you have the “problem” of transactions. if you failover in the middle
>> of a transaction, strange things might happen from the application point of view.
>>
>> the good thing, however, is that stupid middleware is sometimes not able to handle
>> failed connections. however, overall i think it is more of a danger than a benefit.
>
> Maybe I misunderstood the original proposal, but my impression was that the alternative
> servers would be tried only at the time the connection is established, and there would be no
> such problems as you describe.



it would still leave the problem of having a read only on the other side unless you are using BDR or so.
regards,
    hans





pgsql-hackers by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Proposal: Implement failover on libpq connect level.
Next
From: Amit Langote
Date:
Subject: Declarative partitioning