View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000457 | Pgpool-II | General | public | 2019-01-26 01:46 | 2019-01-29 15:56 |
| Reporter | adityakamana | Assigned To | t-ishii | ||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | resolved | Resolution | open | ||
| Product Version | 4.0.2 | ||||
| Summary | 0000457: White_function_list | ||||
| Description | Hello, 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 | ||||
| Additional Information | 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.*'). |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-01-26 01:46 | adityakamana | New Issue | |
| 2019-01-27 09:31 | t-ishii | Note Added: 0002338 | |
| 2019-01-27 09:40 | adityakamana | Note Added: 0002339 | |
| 2019-01-29 15:56 | t-ishii | Assigned To | => t-ishii |
| 2019-01-29 15:56 | t-ishii | Status | new => resolved |
