Re: Libpq support to connect to standby server as priority

Greg Nancarrow <gregn4422@gmail.com>

From: Greg Nancarrow <gregn4422@gmail.com>

To: Daniel Gustafsson <daniel@yesql.se>

Cc: David Steele <david@pgmasters.net>, "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>, Alvaro Herrera <alvherre@2ndquadrant.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>, Elvis Pranskevichus <elprans@gmail.com>

Date: 2020-07-20T01:15:02Z

Lists: pgsql-hackers

Attachments

v17-0001-Enhance-libpq-target_session_attrs-and-add-target_se.patch (application/octet-stream) patch v17-0001

>
> Thanks, but now the tests no longer work as the nodes in the test suite are
> renamed.  While simple enough for a committer to fix, it's always good to see
> the tests pass in the CFBot to make sure the variable name error isn't hiding
> an actual test error.
>

Rebased patch attached, all tests currently working as of Jul 19
(a766d6ca22ac7c233e69c896ae0c5f19de916db4).

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