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

[Tatsuo Ishii]

Yes, perfect.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Thank you for clarification.
> I configured pgPool with master_slave_mode and load_balance_mode enabled. To force read queries from slave server and write queries from master one, I added option backedn_weight with value 1 for slave and 0 for master.
> Although wright now I achieved my goal, I am not quite sure if this is correct configuration or I just found workaround.
> Can you confirm above config or show better way for solving my issue with pgPool?
> Thanks in advance.
> 
> Regards
> Piotr
> 
> ________________________________________
> From: Tatsuo Ishii <ishii at postgresql.org>
> Sent: Friday, November 08, 2013 07:24
> To: Piotr Pawłowski
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 2260] Query distribution between replicated servers
> 
>> 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