Tatsuo, Here is my log. I started pgpool II and then connected in from my laptop and issued a select count(*) from public.accounts. Since this is a simple select, so I'm understanding that it should have gone to the slave.
Here is the log: postg...@tstsrv:/usr/local/pgpool2/etc$ ../bin/pgpool -f ./pgpool.conf -F ./pcp.conf -n -d 2010-10-15 15:05:30 DEBUG: pid 14538: key: listen_addresses 2010-10-15 15:05:30 DEBUG: pid 14538: value: '*' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: port 2010-10-15 15:05:30 DEBUG: pid 14538: value: 9999 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: pcp_port 2010-10-15 15:05:30 DEBUG: pid 14538: value: 9898 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: socket_dir 2010-10-15 15:05:30 DEBUG: pid 14538: value: '/tmp' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: pcp_socket_dir 2010-10-15 15:05:30 DEBUG: pid 14538: value: '/tmp' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: backend_socket_dir 2010-10-15 15:05:30 DEBUG: pid 14538: value: '/tmp' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: pcp_timeout 2010-10-15 15:05:30 DEBUG: pid 14538: value: 10 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: num_init_children 2010-10-15 15:05:30 DEBUG: pid 14538: value: 32 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: max_pool 2010-10-15 15:05:30 DEBUG: pid 14538: value: 4 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: child_life_time 2010-10-15 15:05:30 DEBUG: pid 14538: value: 10 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: connection_life_time 2010-10-15 15:05:30 DEBUG: pid 14538: value: 30 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: child_max_connections 2010-10-15 15:05:30 DEBUG: pid 14538: value: 0 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: client_idle_limit 2010-10-15 15:05:30 DEBUG: pid 14538: value: 0 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: authentication_timeout 2010-10-15 15:05:30 DEBUG: pid 14538: value: 60 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: logdir 2010-10-15 15:05:30 DEBUG: pid 14538: value: '/tmp' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: pid_file_name 2010-10-15 15:05:30 DEBUG: pid 14538: value: '/var/run/pgpool/pgpool.pid' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: replication_mode 2010-10-15 15:05:30 DEBUG: pid 14538: value: false kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: load_balance_mode 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: replication_stop_on_mismatch 2010-10-15 15:05:30 DEBUG: pid 14538: value: false kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: replication_stop_on_mismatch: 0 2010-10-15 15:05:30 DEBUG: pid 14538: key: failover_if_affected_tuples_mismatch 2010-10-15 15:05:30 DEBUG: pid 14538: value: false kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: failover_if_affected_tuples_mismatch: 0 2010-10-15 15:05:30 DEBUG: pid 14538: key: replicate_select 2010-10-15 15:05:30 DEBUG: pid 14538: value: false kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: replicate_select: 0 2010-10-15 15:05:30 DEBUG: pid 14538: key: reset_query_list 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'ABORT; DISCARD ALL' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: extract_string_tokens: token: ABORT 2010-10-15 15:05:30 DEBUG: pid 14538: extract_string_tokens: token: DISCARD ALL 2010-10-15 15:05:30 DEBUG: pid 14538: key: white_function_list 2010-10-15 15:05:30 DEBUG: pid 14538: value: '' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: black_function_list 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'nextval,setval' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: extract_string_tokens: token: nextval 2010-10-15 15:05:30 DEBUG: pid 14538: extract_string_tokens: token: setval 2010-10-15 15:05:30 DEBUG: pid 14538: key: print_timestamp 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: master_slave_mode 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: master_slave_sub_mode 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'stream' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: delay_threshold 2010-10-15 15:05:30 DEBUG: pid 14538: value: 10 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: log_standby_delay 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'always' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: connection_cache 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: health_check_timeout 2010-10-15 15:05:30 DEBUG: pid 14538: value: 20 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: health_check_period 2010-10-15 15:05:30 DEBUG: pid 14538: value: 15 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: health_check_user 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'pgpool' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: failover_command 2010-10-15 15:05:30 DEBUG: pid 14538: value: '' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: failback_command 2010-10-15 15:05:30 DEBUG: pid 14538: value: '' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: fail_over_on_backend_error 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: insert_lock 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: ignore_leading_white_space 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: log_statement 2010-10-15 15:05:30 DEBUG: pid 14538: value: false kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: log_per_node_statement 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: log_connections 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: log_hostname 2010-10-15 15:05:30 DEBUG: pid 14538: value: true kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: parallel_mode 2010-10-15 15:05:30 DEBUG: pid 14538: value: false kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: enable_query_cache 2010-10-15 15:05:30 DEBUG: pid 14538: value: false kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: pgpool2_hostname 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'tstsrv' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: system_db_hostname 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'localhost' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: system_db_port 2010-10-15 15:05:30 DEBUG: pid 14538: value: 6000 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: system_db_dbname 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'pgpool' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: system_db_schema 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'pgpool_catalog' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: system_db_user 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'pgpool' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: system_db_password 2010-10-15 15:05:30 DEBUG: pid 14538: value: '*****' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: backend_hostname0 2010-10-15 15:05:30 DEBUG: pid 14538: value: '' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: backend_port0 2010-10-15 15:05:30 DEBUG: pid 14538: value: 6000 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: pool_config: port slot number 0 2010-10-15 15:05:30 DEBUG: pid 14538: key: backend_hostname1 2010-10-15 15:05:30 DEBUG: pid 14538: value: '192.168.192.1' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: backend_port1 2010-10-15 15:05:30 DEBUG: pid 14538: value: 6000 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: pool_config: port slot number 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: enable_pool_hba 2010-10-15 15:05:30 DEBUG: pid 14538: value: false kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: recovery_user 2010-10-15 15:05:30 DEBUG: pid 14538: value: 'nobody' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: recovery_password 2010-10-15 15:05:30 DEBUG: pid 14538: value: '' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: recovery_1st_stage_command 2010-10-15 15:05:30 DEBUG: pid 14538: value: '' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: recovery_2nd_stage_command 2010-10-15 15:05:30 DEBUG: pid 14538: value: '' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: recovery_timeout 2010-10-15 15:05:30 DEBUG: pid 14538: value: 90 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: client_idle_limit_in_recovery 2010-10-15 15:05:30 DEBUG: pid 14538: value: 0 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: key: lobj_lock_table 2010-10-15 15:05:30 DEBUG: pid 14538: value: '' kind: 4 2010-10-15 15:05:30 DEBUG: pid 14538: key: ssl 2010-10-15 15:05:30 DEBUG: pid 14538: value: false kind: 1 2010-10-15 15:05:30 DEBUG: pid 14538: key: debug_level 2010-10-15 15:05:30 DEBUG: pid 14538: value: 100 kind: 2 2010-10-15 15:05:30 DEBUG: pid 14538: num_backends: 2 total_weight: 0.000000 2010-10-15 15:05:30 DEBUG: pid 14538: backend 0 weight: nan 2010-10-15 15:05:30 DEBUG: pid 14538: backend 1 weight: nan 2010-10-15 15:05:30 DEBUG: pid 14540: I am 14540 2010-10-15 15:05:30 DEBUG: pid 14541: I am 14541 2010-10-15 15:05:30 DEBUG: pid 14542: I am 14542 2010-10-15 15:05:30 DEBUG: pid 14543: I am 14543 2010-10-15 15:05:30 DEBUG: pid 14544: I am 14544 2010-10-15 15:05:30 DEBUG: pid 14545: I am 14545 2010-10-15 15:05:30 DEBUG: pid 14546: I am 14546 2010-10-15 15:05:30 DEBUG: pid 14547: I am 14547 2010-10-15 15:05:30 DEBUG: pid 14548: I am 14548 2010-10-15 15:05:30 DEBUG: pid 14549: I am 14549 2010-10-15 15:05:30 DEBUG: pid 14550: I am 14550 2010-10-15 15:05:30 DEBUG: pid 14551: I am 14551 2010-10-15 15:05:30 DEBUG: pid 14552: I am 14552 2010-10-15 15:05:30 DEBUG: pid 14553: I am 14553 2010-10-15 15:05:30 DEBUG: pid 14554: I am 14554 2010-10-15 15:05:30 DEBUG: pid 14555: I am 14555 2010-10-15 15:05:30 DEBUG: pid 14556: I am 14556 2010-10-15 15:05:30 DEBUG: pid 14557: I am 14557 2010-10-15 15:05:30 DEBUG: pid 14558: I am 14558 2010-10-15 15:05:30 DEBUG: pid 14559: I am 14559 2010-10-15 15:05:30 DEBUG: pid 14560: I am 14560 2010-10-15 15:05:30 DEBUG: pid 14561: I am 14561 2010-10-15 15:05:30 DEBUG: pid 14562: I am 14562 2010-10-15 15:05:30 DEBUG: pid 14563: I am 14563 2010-10-15 15:05:30 DEBUG: pid 14564: I am 14564 2010-10-15 15:05:30 DEBUG: pid 14565: I am 14565 2010-10-15 15:05:30 DEBUG: pid 14566: I am 14566 2010-10-15 15:05:30 DEBUG: pid 14567: I am 14567 2010-10-15 15:05:30 DEBUG: pid 14568: I am 14568 2010-10-15 15:05:30 DEBUG: pid 14569: I am 14569 2010-10-15 15:05:30 DEBUG: pid 14570: I am 14570 2010-10-15 15:05:30 DEBUG: pid 14571: I am 14571 2010-10-15 15:05:30 LOG: pid 14538: pgpool-II successfully started. version 3.0 (umiyameboshi) 2010-10-15 15:05:30 DEBUG: pid 14573: I am 14573 2010-10-15 15:05:30 DEBUG: pid 14573: pool_ssl: SSL requested but SSL support is not available 2010-10-15 15:05:30 DEBUG: pid 14538: starting health checking 2010-10-15 15:05:30 DEBUG: pid 14538: health_check: 0 th DB node status: 1 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: auth kind: 0 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: parameter status data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: backend key data received 2010-10-15 15:05:30 DEBUG: pid 14573: s_do_auth: transaction state: I 2010-10-15 15:05:30 DEBUG: pid 14538: health_check: 1 th DB node status: 3 2010-10-15 15:05:33 DEBUG: pid 14570: I am 14570 accept fd 6 2010-10-15 15:05:33 LOG: pid 14570: connection received: host=[local] 2010-10-15 15:05:33 DEBUG: pid 14570: Protocol Major: 3 Minor: 0 database: prodtest user: postgres 2010-10-15 15:05:33 DEBUG: pid 14570: new_connection: connecting 0 backend 2010-10-15 15:05:33 DEBUG: pid 14570: new_connection: connecting 1 backend 2010-10-15 15:05:33 DEBUG: pid 14570: new_connection: skipping slot 1 because backend_status = 3 2010-10-15 15:05:33 DEBUG: pid 14570: pool_ssl: SSL requested but SSL support is not available 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length: slot: 0 length: 8 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 26 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: application_name value: psql 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 30 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: client_encoding value: SQL_ASCII 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 23 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: DateStyle value: ISO, MDY 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 25 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: integer_datetimes value: on 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 27 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: IntervalStyle value: postgres 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 20 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: is_superuser value: on 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 30 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: server_encoding value: SQL_ASCII 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 25 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: server_version value: 9.0.0 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 35 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: session_authorization value: postgres 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 36 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: standard_conforming_strings value: off 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length2: master slot: 0 length: 24 2010-10-15 15:05:33 DEBUG: pid 14570: 0 th backend: name: TimeZone value: US/Eastern 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length: slot: 0 length: 12 2010-10-15 15:05:33 DEBUG: pid 14570: pool_do_auth: cp->info[i]:0x7f2b818c1000 pid:14577 2010-10-15 15:05:33 DEBUG: pid 14570: pool_send_auth_ok: send pid 14577 to frontend 2010-10-15 15:05:33 DEBUG: pid 14570: select_load_balancing_node: selected backend id is 0 2010-10-15 15:05:33 DEBUG: pid 14570: selected load balancing node: 0 2010-10-15 15:05:33 DEBUG: pid 14570: pool_unset_query_in_progress: done 2010-10-15 15:05:33 DEBUG: pid 14570: pool_unset_skip_reading_from_backends: done 2010-10-15 15:05:33 DEBUG: pid 14570: pool_unset_ignore_till_sync: done 2010-10-15 15:05:33 DEBUG: pid 14570: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2 2010-10-15 15:05:33 DEBUG: pid 14570: ProcessBackendResponse: kind from backend: Z 2010-10-15 15:05:33 DEBUG: pid 14570: pool_read_message_length: slot: 0 length: 5 2010-10-15 15:05:41 DEBUG: pid 14570: ProcessFrontendResponse: kind from frontend Q(51) 2010-10-15 15:05:41 DEBUG: pid 14570: pool_unset_doing_extended_query_message: done 2010-10-15 15:05:41 DEBUG: pid 14570: statement2: select count(*) from public.accounts; 2010-10-15 15:05:41 DEBUG: pid 14570: pool_set_query_in_progress: done 2010-10-15 15:05:41 DEBUG: pid 14570: send_to_where: 2 query: select count(*) from public.accounts; 2010-10-15 15:05:41 DEBUG: pid 14570: function_call_walker: function name: count 2010-10-15 15:05:41 DEBUG: pid 14570: system_catalog_walker: relname: accounts 2010-10-15 15:05:41 LOG: pid 14570: DB node id: 0 backend pid: 14577 statement: SELECT count(*) FROM pg_catalog.pg_proc AS p WHERE p.proname = 'pgpool_regclass' 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: T 2010-10-15 15:05:41 DEBUG: pid 14570: num_fileds: 1 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: D 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: C 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: Z 2010-10-15 15:05:41 LOG: pid 14570: DB node id: 0 backend pid: 14577 statement: SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname = 'pg_namespace' AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog' 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: T 2010-10-15 15:05:41 DEBUG: pid 14570: num_fileds: 1 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: D 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: C 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: Z 2010-10-15 15:05:41 LOG: pid 14570: DB node id: 0 backend pid: 14577 statement: SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.relname = 'accounts' AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog' 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: T 2010-10-15 15:05:41 DEBUG: pid 14570: num_fileds: 1 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: D 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: C 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: Z 2010-10-15 15:05:41 DEBUG: pid 14570: temp_table_walker: relname: accounts 2010-10-15 15:05:41 LOG: pid 14570: DB node id: 0 backend pid: 14577 statement: SELECT count(*) FROM pg_catalog.pg_class AS c, pg_attribute AS a WHERE c.relname = 'pg_class' AND a.attrelid = c.oid AND a.attname = 'relistemp' 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: T 2010-10-15 15:05:41 DEBUG: pid 14570: num_fileds: 1 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: D 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: C 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: Z 2010-10-15 15:05:41 LOG: pid 14570: DB node id: 0 backend pid: 14577 statement: SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.relname = 'accounts' AND c.relistemp 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: T 2010-10-15 15:05:41 DEBUG: pid 14570: num_fileds: 1 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: D 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: C 2010-10-15 15:05:41 DEBUG: pid 14570: do_query: kind: Z 2010-10-15 15:05:41 LOG: pid 14570: DB node id: 0 backend pid: 14577 statement: select count(*) from public.accounts; 2010-10-15 15:05:41 DEBUG: pid 14570: wait_for_query_response: waiting for backend 0 completing the query 2010-10-15 15:05:41 DEBUG: pid 14570: read_kind_from_backend: read kind from 0 th backend T NUM_BACKENDS: 2 2010-10-15 15:05:41 DEBUG: pid 14570: ProcessBackendResponse: kind from backend: T 2010-10-15 15:05:41 DEBUG: pid 14570: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 2 2010-10-15 15:05:41 DEBUG: pid 14570: ProcessBackendResponse: kind from backend: D 2010-10-15 15:05:41 DEBUG: pid 14570: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2 2010-10-15 15:05:41 DEBUG: pid 14570: ProcessBackendResponse: kind from backend: C 2010-10-15 15:05:41 DEBUG: pid 14570: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2 2010-10-15 15:05:41 DEBUG: pid 14570: ProcessBackendResponse: kind from backend: Z 2010-10-15 15:05:41 DEBUG: pid 14570: pool_read_message_length: slot: 0 length: 5 2010-10-15 15:05:41 DEBUG: pid 14570: pool_unset_query_in_progress: done 2010-10-15 15:05:41 DEBUG: pid 14570: pool_unset_query_in_progress: done 2010-10-15 15:05:43 DEBUG: pid 14570: ProcessFrontendResponse: kind from frontend X(58) 2010-10-15 15:05:43 DEBUG: pid 14570: pool_unset_doing_extended_query_message: done 2010-10-15 15:05:43 DEBUG: pid 14570: pool_unset_query_in_progress: done 2010-10-15 15:05:43 DEBUG: pid 14570: pool_unset_query_in_progress: done 2010-10-15 15:05:43 DEBUG: pid 14570: statement2: DISCARD ALL 2010-10-15 15:05:43 DEBUG: pid 14570: pool_set_query_in_progress: done 2010-10-15 15:05:43 DEBUG: pid 14570: send_to_where: 3 query: DISCARD ALL 2010-10-15 15:05:43 LOG: pid 14570: DB node id: 0 backend pid: 14577 statement: DISCARD ALL 2010-10-15 15:05:43 DEBUG: pid 14570: wait_for_query_response: waiting for backend 0 completing the query 2010-10-15 15:05:43 DEBUG: pid 14570: read_kind_from_backend: parameter name: is_superuser value: on 2010-10-15 15:05:43 DEBUG: pid 14570: read_kind_from_backend: parameter name: session_authorization value: postgres 2010-10-15 15:05:43 DEBUG: pid 14570: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2 2010-10-15 15:05:43 DEBUG: pid 14570: ProcessBackendResponse: kind from backend: C 2010-10-15 15:05:43 DEBUG: pid 14570: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2 2010-10-15 15:05:43 DEBUG: pid 14570: ProcessBackendResponse: kind from backend: Z 2010-10-15 15:05:43 DEBUG: pid 14570: pool_read_message_length: slot: 0 length: 5 2010-10-15 15:05:43 DEBUG: pid 14570: pool_unset_query_in_progress: done 2010-10-15 15:05:43 DEBUG: pid 14570: pool_unset_query_in_progress: done 2010-10-15 15:05:43 DEBUG: pid 14570: pool_unset_query_in_progress: done 2010-10-15 15:05:43 DEBUG: pid 14570: pool_connection_pool_timer: set close time 1287169543 2010-10-15 15:05:43 DEBUG: pid 14570: pool_connection_pool_timer: set alarm after 30 seconds 2010-10-15 15:05:45 DEBUG: pid 14538: starting health checking 2010-10-15 15:05:45 DEBUG: pid 14538: health_check: 0 th DB node status: 2 2010-10-15 15:05:45 DEBUG: pid 14538: health_check: 1 th DB node status: 3 On Thu, Oct 14, 2010 at 11:21 AM, Tatsuo Ishii <[email protected]> wrote: > Please start pgpool with -d option to figure out what is wrong... > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp > > > 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 >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
