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

Fri Oct 15 19:08:49 UTC 2010

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:

postgres at 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 <ishii at sraoss.co.jp> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20101015/f04671d2/attachment-0001.html>