[Pgpool-general] understanding backend_weight

Tatsuo Ishii ishii at sraoss.co.jp
Mon Nov 16 13:24:54 UTC 2009


> How should I understand "backend_weight" config variable?
> 
> For example, I have two postgres servers: "local" and "remote".
> 
> I would like to execute all SELECT operations on the "local" server only 
> / mostly.
> 
> 
> What backend_weight should I use?

> backend_hostname0 = 'local'
> backend_weight0 = 1
> 
> backend_hostname1 = 'remote'
> backend_weight1 = 0

This one.
--
Tatsuo Ishii
SRA OSS, Inc. Japan


More information about the Pgpool-general mailing list