Re: Libpq support to connect to standby server as priority

From: Jing Wang <jingwangian(at)gmail(dot)com>
To: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Libpq support to connect to standby server as priority
Date: 2018-01-04 23:25:46
Message-ID: CAF3+xMJdGM=w5PBoKGN99_jwX5Hk=rvM5TrWUcd5BWOaON+v-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Takayuki,

Thanks your reminder.

I will have a look your patch and the review comments and update the patch
soon.

Please leave my current submitted patch now.

--
Regards,
Jing Wang
Fujitsu Australia

2018-01-04 17:40 GMT+11:00 Tsunakawa, Takayuki <
tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>:

> From: Jing Wang [mailto:jingwangian(at)gmail(dot)com]
> > This is a proposal that let libpq support 'prefer-read' option in
> > target_session_attrs in pg_conn. The 'prefer-read' means the libpq will
> > try to connect to a 'read-only' server firstly from the multiple server
> > addresses. If failed to connect to the 'read-only' server then it will
> try
> > to connect to the 'read-write' server.
>
> There's a pending patch I started. I'd be happy if you could continue
> this.
>
> https://commitfest.postgresql.org/15/1148/
>
> Regards
> Takayuki Tsunakawa
>
>

--
Kind regards
Jing

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2018-01-04 23:58:24 Re: [HACKERS] Runtime Partition Pruning
Previous Message Tels 2018-01-04 23:24:53 Re: Faster inserts with mostly-monotonically increasing values