Postgres Pro
Downloads
Home   >   mailing lists

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

From Jing Wang
Subject Re: Libpq support to connect to standby server as priority
Date
Msg-id CAF3+xMJdGM=w5PBoKGN99_jwX5Hk=rvM5TrWUcd5BWOaON+v-A@mail.gmail.com
Whole thread Raw
In response to RE: Libpq support to connect to standby server as priority  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
List pgsql-hackers
Tree view
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.takay@jp.fujitsu.com>:
From: Jing Wang [mailto:jingwangian@gmail.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

pgsql-hackers by date:

Previous
From: "Tels"
Date:
Subject: Re: Faster inserts with mostly-monotonically increasing values
Next
From: David Rowley
Date:
Subject: Re: [HACKERS] Runtime Partition Pruning