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
Cc: Thom Brown <thom(at)linux(dot)com>
Subject: Re: Patch: Implement failover on libpq connect level.
Date: 2016-01-22 19:30:51
Message-ID: 20160122223051.1c7b22f6@wagner.wagner.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On Tue, 19 Jan 2016 14:34:54 +0000
Thom Brown <thom(at)linux(dot)com> wrote:

>
> The segfault issue I originally reported now appears to be resolved.
>
> But now I have another one:
>
> psql
> 'postgresql://thom(at)127(dot)0(dot)0(dot)1:5530,127.0.0.1:5531,127.0.0.1:5532,127.0.0.1:5533/postgres?hostorder=random&readonly=1&failover_timeout=5'
> -c 'show port'

Here is new version of the patch. Now I've reworked hostorder=random and
it seems to work as well as sequential. failover_timeout works too.
I've also found a case when attempt to connect fail when receiving
FATAL message from server which is not properly up yet. So, it is fixed
too.

Addititonally, error messages from all failed connect attempts are not
accumulated now. Only last one is returned.

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

Attachment Content-Type Size
libpq-failover-6.patch text/x-patch 35.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2016-01-22 19:36:15 Re: Patch: Implement failover on libpq connect level.
Previous Message Daniel Verite 2016-01-22 18:53:57 Re: [patch] Proposal for \crosstabview in psql

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alvaro Herrera 2016-01-22 19:36:15 Re: Patch: Implement failover on libpq connect level.
Previous Message Dave Cramer 2016-01-22 19:28:46 Re: Wrong link not pointing to the release tarball