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