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

[Siva U]

Thank you very much Tatsuo.

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.

Is we have any method to handle all future creating function's?

Regards,
Siva.

On Tue, Sep 17, 2019, 5:22 PM Tatsuo Ishii <ishii at sraoss.co.jp wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190917/1a8758de/attachment.html>