pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hubert Zhang <zhubert@vmware.com>
Cc: tsunakawa.takay@fujitsu.com <tsunakawa.takay@fujitsu.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: Multiple hosts in connection string failed to failover in non-hot standby mode
Date: Mon, 11 Jan 2021 10:15:52 -0500
Message-ID: <864104.1610378152@sss.pgh.pa.us> (raw)
In-Reply-To: <SN6PR05MB4909B53E8D3D8523D72328EAC9AB0@SN6PR05MB4909.namprd05.prod.outlook.com>
References: <BN6PR05MB3492948E4FD76C156E747E8BC9160@BN6PR05MB3492.namprd05.prod.outlook.com>
	<TYAPR01MB299012CAC510D2644AEC2246FE160@TYAPR01MB2990.jpnprd01.prod.outlook.com>
	<BN6PR05MB3492DFB2FF32B771172CC2F2C9170@BN6PR05MB3492.namprd05.prod.outlook.com>
	<229507.1610056206@sss.pgh.pa.us>
	<770711.1610318330@sss.pgh.pa.us>
	<810463.1610333794@sss.pgh.pa.us>
	<SN6PR05MB4909B53E8D3D8523D72328EAC9AB0@SN6PR05MB4909.namprd05.prod.outlook.com>

Hubert Zhang <zhubert@vmware.com> writes:
> As for patch 0004, find ':' after "could not connect to" may failed when error message like:
> "could not connect to host "localhost" (::1), port 12345: Connection refused", where p2 will point to "::1" instead of ": Connection refused". But since it's only used for test case, we don't need to filter the error message precisely.

Excellent point, and I think that could happen on a Windows installation.
We can make it look for ": " instead of just ':', and that'll reduce the
odds of trouble.

			regards, tom lane





view thread (38+ messages)  latest in thread

Message-ID: <864104.1610378152@sss.pgh.pa.us>
Permalink:  ../864104.1610378152@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/864104.1610378152@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, zhubert@vmware.com, tsunakawa.takay@fujitsu.com
  Subject: Re: Multiple hosts in connection string failed to failover in non-hot standby mode
  In-Reply-To: <864104.1610378152@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox