Re: Patch: Implement failover on libpq connect level.

From: Victor Wagner <vitus(at)wagner(dot)pp(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Patch: Implement failover on libpq connect level.
Date: 2016-08-26 04:47:30
Message-ID: 20160826074730.093e5ee5@wagner.wagner.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On Fri, 26 Aug 2016 10:10:33 +0530
Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com> wrote:

> On Thu, Mar 17, 2016 at 4:47 AM, David Steele <david(at)pgmasters(dot)net>
> wrote:
> >Since there has been no response from the author I have marked this
> >patch
> "returned with feedback". Please feel free >to resubmit for 9.7!
> I have started to work on this patch, and tried to fix some of the
> issues discussed above. The most recent patch 06 has fixed many
> issues which was raised previously which include indefinite looping,
> crashes. And, some of the issues which remain pending are.

Although I have not resubmutted my patch yet, I've continue to work on
it, so you can see my last version on

https://www.wagner.pp.ru/fossil/pgfailover.

It seems that I've already fixed some of issues you mentioned below.
Also I've added testsuite, which is incomplete.

> JFYI Interestingly PostgreSql JDBC driver have following options
> targetServerType=any|master|slave|preferSlave for same purpose.

Probably we should havbe a comptibility alias.

--
Victor Wagner <vitus(at)wagner(dot)pp(dot)ru>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2016-08-26 05:52:36 Re: Transactions involving multiple postgres foreign servers
Previous Message Mithun Cy 2016-08-26 04:40:33 Re: Patch: Implement failover on libpq connect level.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Adam Rauch 2016-08-27 04:31:40 Simple queries with JDBC escaped scalar functions result in exceptions
Previous Message Mithun Cy 2016-08-26 04:40:33 Re: Patch: Implement failover on libpq connect level.