Postgres Pro
Downloads
Home   >   mailing lists

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

From Hubert Zhang
Subject Multiple hosts in connection string failed to failover in non-hot standby mode
Date
Msg-id BN6PR05MB3492948E4FD76C156E747E8BC9160@BN6PR05MB3492.namprd05.prod.outlook.com
Whole thread Raw
Responses RE: Multiple hosts in connection string failed to failover in non-hot standby mode  ("tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>)
Re: Multiple hosts in connection string failed to failover in non-hot standby mode  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
Tree view
Hi hackers,

Libpq has supported to specify multiple hosts in connection string and enable auto failover when the previous PostgreSQL instance 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 list are not tried.' 
I'm wondering is it a feature by design or a bug? If it's a bug, I plan to fix it.

Thanks,
Hubert Zhang

pgsql-hackers by date:

Previous
From: Nikolay Samokhvalov
Date:
Subject: Re: Add important info about ANALYZE after create Functional Index
Next
From: Peter Smith
Date:
Subject: Question about make coverage-html