[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

More information about the pgpool-general mailing list