| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
| Cc: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, Jing Wang <jingwangian(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Libpq support to connect to standby server as priority |
| Date: | 2019-01-18 00:28:30 |
| Message-ID: | CADK3HHLhXstomksx73FUqBc2bgBh2BvTByFUCvB1sE1mfD_zpw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 17 Jan 2019 at 19:09, Tsunakawa, Takayuki <
tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> wrote:
> From: Dave Cramer [mailto:pg(at)fastcrypt(dot)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 seemed to try each host once
> in a while loop.
>
You are correct looking at the code again. On the initial connection
attempt we only try once.
Dave Cramer
davec(at)postgresintl(dot)com
www.postgresintl.com
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2019-01-18 00:38:38 | Re: Libpq support to connect to standby server as priority |
| Previous Message | Dave Cramer | 2019-01-18 00:27:34 | Re: Libpq support to connect to standby server as priority |