[pgpool-general: 6714] Re: Help to handle functions contains DML statements using black_list_functions option

[Tatsuo Ishii]

Please do not cross post messages.

> We have deployed the application on prod and using pool for load balanceing
> with master slave mode.
> 
> We have some of the function's which contains INSERT, UPDATE, DELETE
> statements.
> 
> While load balancing, pgpool is sending requests to the Slaves even the
> functions which contains DML statements.
> 
> We are getting this issue again and again.
> We found some option (black_list_functions )for this to route the functions
> to master which contain DML statements.

As you already know, black_list_functions can be used for your pupose.

> Could you please suggest how to use overcome this issue and help us with
> available options in pgpool to handle this kind of situations.

I wonder what's wrong with using black_list_functions.

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