No subject


Mon Nov 14 14:56:52 JST 2011


> For a query to be load balanced, all the following requirements must be met:
>  > it's not SELECT FOR UPDATE nor FOR SHARE


[pgpool.conf]
load_balance_mode = on
ignore_leading_white_space = on
white_function_list = ''
black_function_list = 'currval,lastval,nextval,setval'
master_slave_mode = on
master_slave_sub_mode = 'stream'
sr_check_period = 10
sr_check_user = 'pgpoolstream'
sr_check_password = 'xxx'
delay_threshold = 10000000
follow_master_command = ''

# pgpool --version
pgpool-II version 3.1.3 (hatsuiboshi)
# uname -a
Linux 2.6.18-194.el5 #1 SMP Fri Apr 2 14:58:14
EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/redhat-release
CentOS release 5.5 (Final)

thanks


More information about the pgpool-general mailing list