[pgpool-general: 2262] Re: Query distribution between replicated servers
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'
SRA OSS, Inc. Japan
More information about the pgpool-general