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