pgsql: Try next host after a "cannot connect now" failure. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Try next host after a "cannot connect now" failure.
Date
Msg-id E1kz2cL-0006Vi-Tq@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Try next host after a "cannot connect now" failure.

If a server returns ERRCODE_CANNOT_CONNECT_NOW, try the next host,
if multiple host names have been provided.  This allows dealing
gracefully with standby servers that might not be in hot standby mode
yet.

In the wake of the preceding commit, it might be plausible to retry
many more error cases than we do now, but I (tgl) am hesitant to
move too aggressively on that --- it's not clear it'd be desirable
for cases such as bad-password, for example.  But this case seems
safe enough.

Hubert Zhang, reviewed by Takayuki Tsunakawa

Discussion: https://postgr.es/m/BN6PR05MB3492948E4FD76C156E747E8BC9160@BN6PR05MB3492.namprd05.prod.outlook.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c1d589571c497a952d7fbe40d9828655859d746f

Modified Files
--------------
src/interfaces/libpq/fe-connect.c | 14 ++++++++++++++
1 file changed, 14 insertions(+)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: In libpq, always append new error messages to conn->errorMessage
Next
From: Tom Lane
Date:
Subject: pgsql: Rethink SQLSTATE code for ERRCODE_IDLE_SESSION_TIMEOUT.