[pgpool-general: 3996] Re: q: sending SQL to a specific node?

[Tatsuo Ishii]

> 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