[pgpool-general: 3996] Re: q: sending SQL to a specific node?
Tatsuo Ishii
ishii at postgresql.org
Fri Aug 21 08:28:21 JST 2015
> Hi,
>
> Suppose I have a simple, two-node master/slave, streaming replication
> set up.
>
> How would I run say `select * from pg_stat_activity;' against a
> specific node?
You can rediect to master by using SQL comments.
/*NO LOAD BALANCE*/ select * from pg_stat_activity;
There's no way to redirect to standby execpt tweaking weight
parameter, but this will redirect all SELECT to standby, probably
which is not what you want.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list