[pgpool-general: 1504] Re: Load balancing changes between 2.x and 3.x

[Tatsuo Ishii]

> On 03/14/2013 04:25 PM, Tatsuo Ishii wrote:
> 
>>> It will not get load balanced. How do we achieve the same behavior in
>>> 3.x?
>>
>> I'm not sure what you want to do...
>>
>> If "select update_function();" is sent to standby node because of load
>> balance, PostgreSQL will not accept the query because it tries to
>> update standby database, no?
> 
> Correct. However, it is my understanding that if I am running 2.x and
> I do this:
> 
> BEGIN;
> SELECT update_function(); -- write stuff to database
> COMMIT;
> 
> It will not be load balanced. However, if I am using 3.x it would
> be. What I want to be able to do is execute functions via pgpool 3.x
> and have it not be load balanced.

Oh I see. You can specify white_function_list and black_function_list
directive. i.e.

white_function_list = ''
black_function_list = 'update_function'

will load balance any function except "update_function".
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp