[pgpool-general: 6714] Re: Help to handle functions contains DML statements using black_list_functions option
ishii at sraoss.co.jp
Tue Sep 17 20:52:39 JST 2019
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
> 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.
SRA OSS, Inc. Japan
More information about the pgpool-general