RE: Libpq support to connect to standby server as priority - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject RE: Libpq support to connect to standby server as priority
Date
Msg-id 0A3221C70F24FB45833433255569204D1FB6947A@G01JPEXMBYT05
Whole thread Raw
In response to Re: Libpq support to connect to standby server as priority  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Libpq support to connect to standby server as priority  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-hackers
From: Dave Cramer [mailto:pg@fastcrypt.com]
>     >> 2) If there's no node on which pg_is_in_recovery() returns false,
> then
>     >>    we need to retry until we find it. To not retry forever, there
>     >>    should be a timeout counter parameter.

> Checking the code I see we actually use show transaction_read_only.

Also, does PgJDBC really repeat connection attempts for a user-specified duration?  Having a quick look at the code, it
seemedto try each host once in a while loop.
 


Regards
Takayuki Tsunakawa



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Fixing findDependentObjects()'s dependency on scan order(regressions in DROP diagnostic messages)
Next
From: Tatsuo Ishii
Date:
Subject: Re: Libpq support to connect to standby server as priority