[pgpool-general: 3996] Re: q: sending SQL to a specific node?
ishii at postgresql.org
Fri Aug 21 08:28:21 JST 2015
> 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.
SRA OSS, Inc. Japan
More information about the pgpool-general