From: Jing Wang [mailto:jingwang...@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