[pgpool-committers: 9440] pgpool: Feature: allow to route queries to a specific backend node for

Bo Peng pengbo at sraoss.co.jp
Tue Jun 13 14:57:13 JST 2023


Feature: allow to route queries to a specific backend node for a specific user connection.

This commit adds a new parameter "user_redirect_preference_list" to
allow to send SELECT queries to a specific backend node for a
specific user connection.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=36d695d8ce875c454610159d89b899ab2c076603

Modified Files
--------------
doc.ja/src/sgml/loadbalance.sgml                   | 225 ++++++++++++++++-----
doc/src/sgml/loadbalance.sgml                      | 173 +++++++++++-----
src/config/pool_config_variables.c                 |  56 +++++
src/include/pool_config.h                          |  11 +
src/protocol/pool_pg_utils.c                       |  44 +++-
src/sample/pgpool.conf.sample-stream               |   5 +
.../regression/tests/008.dbredirect/select.pgbench |   2 +-
.../tests/008.dbredirect/select1.pgbench           |   2 +-
src/test/regression/tests/008.dbredirect/test.sh   | 205 +++++++++++++------
src/utils/pool_process_reporting.c                 |   5 +
10 files changed, 569 insertions(+), 159 deletions(-)



More information about the pgpool-committers mailing list