View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0000457||Pgpool-II||[All Projects] General||public||2019-01-26 01:46||2019-01-29 15:56|
|Target Version||Fixed in Version|
I have installed pgpool 4.0.2 with one master and one standby postgresql hosts in streaming replication mode. Out intention to use pgpool is strictly for connection pooling and load balancing.
I am looking to load balance certain stored procedures that don't make any changes on the primary database.
My current setting for lb_weight is 0.5 and 0.5 for both primary and standby databases. We call the stored procedures like this:
select * from customer.get_account_detail(123, 456);
What would be the entry in the white_function_list if I want to load balance this function all the time to the standby (can I do this at all)?
white_function_list='get_account_detail.*' (is this correct?)
|Steps To Reproduce||NA|
|Tags||No tags attached.|
||Yes, that's correct. Pgpool-II silently ignores schema qualification (in your case "customer") from an input SQL, then compares with the white_function list. So function names in white_function_list should not have schema qualification.|
Great. Thanks for the confirmation.
Glad that this is correct (white_function_list='get_account_detail.*').