Re: Libpq support to connect to standby server as priority

Greg Nancarrow <gregn4422@gmail.com>

From: Greg Nancarrow <gregn4422@gmail.com>

To: Alvaro Herrera from 2ndQuadrant <alvherre@alvh.no-ip.org>

Cc: "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>, Haribabu Kommi <kommi.haribabu@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Laurenz Albe <laurenz.albe@cybertec.at>, Tom Lane <tgl@sss.pgh.pa.us>, Dave Cramer <pg@fastcrypt.com>, Jing Wang <jingwangian@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2019-10-01T10:51:21Z

Lists: pgsql-hackers

Attachments

v14-0001-libpq-target_session_attrs-read_write-prefer_read-read_only.patch (application/octet-stream) patch v14-0001
v14-0003-Server-recovery-mode-handling.patch (application/octet-stream) patch v14-0003
v14-0002-libpq-target_session_attrs-primary-prefer_standby-standby.patch (application/octet-stream) patch v14-0002

On Wed, Sep 11, 2019 at 10:17 AM Alvaro Herrera from 2ndQuadrant
<alvherre@alvh.no-ip.org> wrote:
>
> Oh, oops. Here they are then.
>

With the permission of the original patch author, Haribabu Kommi, I’ve
rationalized the existing 8 patches into 3 patches, merging patches
1-5 and 6-7, and tidying up some documentation and code comments. I
also rebased them to the latest PG12 source code (as of October 1,
2019). The patch code itself is the same, except for some version
checks that I have updated to target the features for PG13 instead of
PG12.
I’ve attached the updated patches.

Regards,
Greg Nancarrow
Fujitsu Australia

Commits

Make test_target_session_attrs more robust against connection failure.
- 3769e11a3183 14.0 landed
Extend the abilities of libpq's target_session_attrs parameter.
- ee28cacf619f 14.0 landed
Mark default_transaction_read_only as GUC_REPORT.
- d16f8c8e416d 14.0 landed
Introduce a new GUC_REPORT setting "in_hot_standby".
- bf8a662c9afa 14.0 landed
Avoid spamming the client with multiple ParameterStatus messages.
- 2432b1a04087 14.0 landed
Avoid harmless Valgrind no-buffer-pin errors.
- a766d6ca22ac 14.0 cited
Restructure libpq code to remove some duplicity
- b438e7e7a1c5 13.0 landed
libpq: Add target_session_attrs parameter.
- 721f7bd3cbcc 10.0 cited