<div dir="auto">Thank you very much Tatsuo. <div dir="auto"><br></div><div dir="auto">In my case , team is continuing creating function's and every time we have to update this list in black_list_function and this seems difficult. </div><div dir="auto"><br></div><div dir="auto">Is we have any method to handle all future creating function's? </div><div dir="auto"><br></div><div dir="auto">Regards, </div><div dir="auto">Siva.</div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, Sep 17, 2019, 5:22 PM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Please do not cross post messages.<br>
<br>
> We have deployed the application on prod and using pool for load balanceing<br>
> with master slave mode.<br>
> <br>
> We have some of the function's which contains INSERT, UPDATE, DELETE<br>
> statements.<br>
> <br>
> While load balancing, pgpool is sending requests to the Slaves even the<br>
> functions which contains DML statements.<br>
> <br>
> We are getting this issue again and again.<br>
> We found some option (black_list_functions )for this to route the functions<br>
> to master which contain DML statements.<br>
<br>
As you already know, black_list_functions can be used for your pupose.<br>
<br>
> Could you please suggest how to use overcome this issue and help us with<br>
> available options in pgpool to handle this kind of situations.<br>
<br>
I wonder what's wrong with using black_list_functions.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div>