> On 18 Aug 2015, at 11:19, Albe Laurenz <laurenz.a...@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 -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers