[pgpool-general: 6111] Re: How can I send a query to any replication node?
Bo Peng
pengbo at sraoss.co.jp
Thu May 31 14:46:14 JST 2018
Hi,
> There is the comment /*NO LOAD BALANCE*/ to sent a query to the primary
> node... is there a similar way to send the query to a replication node.
You mean master_slave_mode using PostgreSQL streaming replication?
It can not be configure for particular standby node.
But you can send all SELECT queries to standby node by using following parameters:
backend_weight0 = 0
backend_weight1 = 1
Also you can specify the list of "database-name:node id" pairs to
send SELECT queries to a particular backend node for a particular database connection.
database_redirect_preference_list
http://www.pgpool.net/docs/latest/en/html/runtime-config-load-balancing.html#GUC-DATABASE-REDIRECT-PREFERENCE-LIST
On Wed, 30 May 2018 08:56:17 -0400
Araujo Manuel Emilio <emilio.araujo at gmail.com> wrote:
> Hello guys.
>
> There is the comment /*NO LOAD BALANCE*/ to sent a query to the primary
> node... is there a similar way to send the query to a replication node.
>
> Environment:
> - pgpool version: 3.6.4 (subaruboshi)
> - nodes count: 2 (primary and replicated).
> - replication mode: PostgreSQL native, hot standby streaming replication
>
>
> Regards,
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general
mailing list