[Pgpool-general] pgpool configuration file question

Tatsuo Ishii ishii at sraoss.co.jp
Thu Aug 11 00:14:47 UTC 2011


> http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html
> states the following:
> 
>  
> 
> "
> 
> backend_weight 
> 
> ... However, *values cannot be updated so you must restart pgpool-II in
> that case*.
> 
>  
> 
> In pgpool-II 2.2.6/2.3 *or later, you can change this value by
> re-loading the configuration file*. This will take effect only for new
> established client sessions. This is useful if you want to prevent any
> query sent to slaves to perform some administrative work in master/slave
> mode. 
> 
> "
> 
>  
> 
> Which of the text enclosed with asterisks above is correct?

Thanks for pointing it out.  Backend_wight can be changed by reloading
pgpool.conf. So latter is correct. I will fix CVS HEAD and 3.0-stable
tree.
--
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