[pgpool-general: 2262] Re: Query distribution between replicated servers

Tatsuo Ishii ishii at postgresql.org
Fri Nov 8 15:24:01 JST 2013

> I am new with pgPool.
> I have two psql servers replicated with slony (master/slave).
> I would like to make read queries on slave only, while write queries should go to master only (obvious).
> Is it possible to achieve such configuraion with pgPool? IF yes - could you give me some tips in which mode should pgPool run in order to perform as described above.
> Thank you in advance for any help.

Yes, you can. 

master_slave_mode = on
master_slave_sub_mode = 'slony'
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