Re: Multiple hosts in connection string failed to failover in non-hot standby mode - Mailing list pgsql-hackers

From Noah Misch
Subject Re: Multiple hosts in connection string failed to failover in non-hot standby mode
Date
Msg-id 20201028103734.GB3785151@rfd.leadboat.com
Whole thread Raw
In response to Multiple hosts in connection string failed to failover in non-hot standby mode  (Hubert Zhang <zhubert@vmware.com>)
List pgsql-hackers
On Tue, Oct 27, 2020 at 07:14:14AM +0000, Hubert Zhang wrote:
> Libpq has supported to specify multiple hosts in connection string and enable auto failover when the previous
PostgreSQLinstance cannot be accessed.
 
> But when I tried to enable this feature for a non-hot standby, it cannot do the failover with the following
messages.
> 
> psql: error: could not connect to server: FATAL:  the database system is starting up
> 
> Document says ' If a connection is established successfully, but authentication fails, the remaining hosts in the
listare not tried.'
 
> I'm wondering is it a feature by design or a bug? If it's a bug, I plan to fix it.

I felt it was a bug, but the community as a whole may or may not agree:
https://postgr.es/m/flat/16508-1a63222835164566%40postgresql.org



pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: cutting down the TODO list thread
Next
From: Hubert Zhang
Date:
Subject: Re: Multiple hosts in connection string failed to failover in non-hot standby mode