[Pgpool-general] Help getting pgpool setup with hot standby.

[Chris Hoover]

I am having difficulty getting pgpoolII 3.0 to use my hot standby.  Can
anyone offer advice?

Basically, I am not seeing health checks, and am not seeing any queries sent
to the hot standby.  This must be a configuration issue, but I can't find
it.

Thanks,

Chris

Here is my config:
-----

listen_addresses = '*'
port = 9999
pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
pcp_timeout = 10
num_init_children = 32
max_pool = 4
child_life_time = 10
connection_life_time = 30
child_max_connections = 0
client_idle_limit = 0
authentication_timeout = 60
logdir = '/tmp'
pid_file_name = '/var/run/pgpool/pgpool.pid'
replication_mode = false
load_balance_mode = true
replication_stop_on_mismatch = false
failover_if_affected_tuples_mismatch = false
replicate_select = false
reset_query_list = 'ABORT; DISCARD ALL'
white_function_list = ''
black_function_list = 'nextval,setval'
print_timestamp = true
master_slave_mode = true
master_slave_sub_mode = 'stream'
delay_threshold = 10
log_standby_delay = 'always'
connection_cache = true
health_check_timeout = 20
health_check_period = 1
health_check_user = 'pgpool'
failover_command = ''
failback_command = ''
fail_over_on_backend_error = true
insert_lock = true
ignore_leading_white_space = true
log_statement = false
log_per_node_statement = true
log_connections = true
log_hostname = true
parallel_mode = false
enable_query_cache = false
pgpool2_hostname = 'testdb1'
system_db_hostname = 'localhost'
system_db_port = 6000
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = 'password'
backend_hostname0 = ''
backend_port0 = 6000
backend_hostname1 = '192.168.192.1'
backend_port1 = 6000
enable_pool_hba = false
recovery_user = 'nobody'
recovery_password = ''
recovery_1st_stage_command = ''
recovery_2nd_stage_command = ''
recovery_timeout = 90
client_idle_limit_in_recovery = 0
lobj_lock_table = ''
ssl = false
debug_level = 100
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20101014/c03a0d0d/attachment.html>