2012-12-19 10:14:39 DEBUG: pid 4571: key: listen_addresses 2012-12-19 10:14:39 DEBUG: pid 4571: value: '*' kind: 4 2012-12-19 10:14:39 DEBUG: pid 4571: key: port 2012-12-19 10:14:39 DEBUG: pid 4571: value: 9999 kind: 2 2012-12-19 10:14:39 DEBUG: pid 4571: key: socket_dir 2012-12-19 10:14:39 DEBUG: pid 4571: value: '/tmp' kind: 4 2012-12-19 10:14:39 DEBUG: pid 4571: key: pcp_port 2012-12-19 10:14:39 DEBUG: pid 4571: value: 9898 kind: 2 2012-12-19 10:14:39 DEBUG: pid 4571: key: pcp_socket_dir 2012-12-19 10:14:39 DEBUG: pid 4571: value: '/tmp' kind: 4 2012-12-19 10:14:39 DEBUG: pid 4571: key: enable_pool_hba 2012-12-19 10:14:39 DEBUG: pid 4571: value: on kind: 1 2012-12-19 10:14:39 DEBUG: pid 4571: key: authentication_timeout 2012-12-19 10:14:39 DEBUG: pid 4571: value: 60 kind: 2 2012-12-19 10:14:39 DEBUG: pid 4571: key: ssl 2012-12-19 10:14:39 DEBUG: pid 4571: value: off kind: 1 2012-12-19 10:14:39 DEBUG: pid 4571: key: num_init_children 2012-12-19 10:14:39 DEBUG: pid 4571: value: 32 kind: 2 2012-12-19 10:14:39 DEBUG: pid 4571: key: max_pool 2012-12-19 10:14:39 DEBUG: pid 4571: value: 4 kind: 2 2012-12-19 10:14:39 DEBUG: pid 4571: key: child_life_time 2012-12-19 10:14:39 DEBUG: pid 4571: value: 300 kind: 2 2012-12-19 10:14:39 DEBUG: pid 4571: key: child_max_connections 2012-12-19 10:14:39 DEBUG: pid 4571: value: 0 kind: 2 2012-12-19 10:14:39 DEBUG: pid 4571: key: connection_life_time 2012-12-19 10:14:39 DEBUG: pid 4571: value: 0 kind: 2 2012-12-19 10:14:39 DEBUG: pid 4571: key: client_idle_limit 2012-12-19 10:14:39 DEBUG: pid 4571: value: 0 kind: 2 2012-12-19 10:14:39 DEBUG: pid 4571: key: log_destination 2012-12-19 10:14:39 DEBUG: pid 4571: value: 'stderr' kind: 4 2012-12-19 10:14:39 DEBUG: pid 4571: key: print_timestamp 2012-12-19 10:14:39 DEBUG: pid 4571: value: on kind: 1 2012-12-19 10:14:39 DEBUG: pid 4571: key: log_connections 2012-12-19 10:14:39 DEBUG: pid 4571: value: off kind: 1 2012-12-19 10:14:39 DEBUG: pid 4571: key: log_hostname 2012-12-19 10:14:39 DEBUG: pid 4571: value: off kind: 1 2012-12-19 10:14:39 DEBUG: pid 4571: key: log_statement 2012-12-19 10:14:39 DEBUG: pid 4571: value: off kind: 1 2012-12-19 10:14:39 DEBUG: pid 4571: key: log_per_node_statement 2012-12-19 10:14:39 DEBUG: pid 4571: value: off kind: 1 2012-12-19 10:14:39 DEBUG: pid 4571: key: log_standby_delay 2012-12-19 10:14:39 DEBUG: pid 4571: value: 'none' kind: 4 2012-12-19 10:14:39 DEBUG: pid 4571: key: syslog_facility 2012-12-19 10:14:39 DEBUG: pid 4571: value: 'LOCAL0' kind: 4 2012-12-19 10:14:39 DEBUG: pid 4571: key: syslog_ident 2012-12-19 10:14:39 DEBUG: pid 4571: value: 'pgpool' kind: 4 2012-12-19 10:14:39 DEBUG: pid 4571: key: debug_level 2012-12-19 10:14:39 DEBUG: pid 4571: value: 0 kind: 2 2012-12-19 10:14:39 LOG: pid 4571: pool_config: backend_socket_dir is deprecated, please use backend_hostname 2012-12-19 10:14:39 DEBUG: pid 4571: loading "/usr/local/etc/pool_hba.conf" for client authentication configuration file 2012-12-19 10:14:39 DEBUG: pid 4572: I am 4572 2012-12-19 10:14:39 DEBUG: pid 4572: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4573: I am 4573 2012-12-19 10:14:39 DEBUG: pid 4573: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4574: I am 4574 2012-12-19 10:14:39 DEBUG: pid 4574: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4575: I am 4575 2012-12-19 10:14:39 DEBUG: pid 4575: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4576: I am 4576 2012-12-19 10:14:39 DEBUG: pid 4576: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4577: I am 4577 2012-12-19 10:14:39 DEBUG: pid 4577: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4578: I am 4578 2012-12-19 10:14:39 DEBUG: pid 4578: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4579: I am 4579 2012-12-19 10:14:39 DEBUG: pid 4579: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4580: I am 4580 2012-12-19 10:14:39 DEBUG: pid 4580: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4581: I am 4581 2012-12-19 10:14:39 DEBUG: pid 4581: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4582: I am 4582 2012-12-19 10:14:39 DEBUG: pid 4582: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4583: I am 4583 2012-12-19 10:14:39 DEBUG: pid 4583: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4584: I am 4584 2012-12-19 10:14:39 DEBUG: pid 4584: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4585: I am 4585 2012-12-19 10:14:39 DEBUG: pid 4585: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4586: I am 4586 2012-12-19 10:14:39 DEBUG: pid 4586: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4587: I am 4587 2012-12-19 10:14:39 DEBUG: pid 4587: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4588: I am 4588 2012-12-19 10:14:39 DEBUG: pid 4588: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4589: I am 4589 2012-12-19 10:14:39 DEBUG: pid 4589: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4590: I am 4590 2012-12-19 10:14:39 DEBUG: pid 4590: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4591: I am 4591 2012-12-19 10:14:39 DEBUG: pid 4591: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4592: I am 4592 2012-12-19 10:14:39 DEBUG: pid 4592: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4593: I am 4593 2012-12-19 10:14:39 DEBUG: pid 4593: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4594: I am 4594 2012-12-19 10:14:39 DEBUG: pid 4594: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4595: I am 4595 2012-12-19 10:14:39 DEBUG: pid 4595: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4596: I am 4596 2012-12-19 10:14:39 DEBUG: pid 4596: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4597: I am 4597 2012-12-19 10:14:39 DEBUG: pid 4597: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4598: I am 4598 2012-12-19 10:14:39 DEBUG: pid 4598: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4599: I am 4599 2012-12-19 10:14:39 DEBUG: pid 4599: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4600: I am 4600 2012-12-19 10:14:39 DEBUG: pid 4600: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4601: I am 4601 2012-12-19 10:14:39 DEBUG: pid 4601: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4602: I am 4602 2012-12-19 10:14:39 DEBUG: pid 4602: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4603: I am 4603 2012-12-19 10:14:39 DEBUG: pid 4603: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 LOG: pid 4571: pgpool-II successfully started. version 3.2.0 (namameboshi) 2012-12-19 10:14:39 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:39 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:39 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:39 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:39 DEBUG: pid 4571: do_query: extended:0 query:SELECT pg_is_in_recovery() 2012-12-19 10:14:39 DEBUG: pid 4571: do_query: kind: T 2012-12-19 10:14:39 DEBUG: pid 4571: do_query: row description received 2012-12-19 10:14:39 DEBUG: pid 4571: num_fileds: 1 2012-12-19 10:14:39 DEBUG: pid 4571: do_query: kind: D 2012-12-19 10:14:39 DEBUG: pid 4571: do_query: data row received 2012-12-19 10:14:39 DEBUG: pid 4571: do_query: kind: C 2012-12-19 10:14:39 DEBUG: pid 4571: do_query: Command complete received 2012-12-19 10:14:39 DEBUG: pid 4571: do_query: kind: Z 2012-12-19 10:14:39 DEBUG: pid 4571: do_query: Ready for query 2012-12-19 10:14:39 LOG: pid 4571: find_primary_node: primary node id is 0 2012-12-19 10:14:39 DEBUG: pid 4571: starting health checking 2012-12-19 10:14:39 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:14:39 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:39 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:39 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:39 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:39 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:14:39 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:39 DEBUG: pid 4605: I am 4605 2012-12-19 10:14:39 DEBUG: pid 4605: pool_initialize_private_backend_status: initialize backend status 2012-12-19 10:14:39 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:39 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:39 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:44 DEBUG: pid 4571: starting health checking 2012-12-19 10:14:44 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:14:44 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:44 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:44 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:44 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:44 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:14:44 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:44 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:44 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:44 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:49 DEBUG: pid 4571: starting health checking 2012-12-19 10:14:49 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:14:49 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:49 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:49 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:49 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:49 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:14:49 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:49 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:49 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:49 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:54 DEBUG: pid 4571: starting health checking 2012-12-19 10:14:54 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:14:54 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:54 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:54 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:54 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:54 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:14:54 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:54 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:54 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:54 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:59 DEBUG: pid 4571: starting health checking 2012-12-19 10:14:59 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:14:59 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:59 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:59 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:59 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:14:59 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:14:59 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:14:59 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:14:59 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:14:59 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:04 DEBUG: pid 4571: starting health checking 2012-12-19 10:15:04 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:15:04 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:04 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:04 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:04 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:04 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:15:04 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:04 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:04 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:04 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:09 DEBUG: pid 4571: starting health checking 2012-12-19 10:15:09 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:15:09 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:09 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:09 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:09 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:09 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:15:09 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:09 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:09 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:09 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:14 DEBUG: pid 4571: starting health checking 2012-12-19 10:15:14 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:15:14 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:14 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:14 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:14 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:14 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:15:14 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:14 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:14 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:14 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:19 DEBUG: pid 4571: starting health checking 2012-12-19 10:15:19 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:15:19 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:19 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:19 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:19 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:19 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:15:19 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:19 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:19 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:19 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:24 DEBUG: pid 4571: starting health checking 2012-12-19 10:15:24 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:15:24 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:24 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:24 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:24 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:24 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:15:24 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:24 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:24 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:24 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:29 DEBUG: pid 4571: starting health checking 2012-12-19 10:15:29 DEBUG: pid 4571: health_check: 0 th DB node status: 1 2012-12-19 10:15:29 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:29 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:29 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:29 DEBUG: pid 4571: s_do_auth: transaction state: I 2012-12-19 10:15:29 DEBUG: pid 4571: health_check: 1 th DB node status: 1 2012-12-19 10:15:29 DEBUG: pid 4571: pool_ssl: SSL requested but SSL support is not available 2012-12-19 10:15:29 DEBUG: pid 4571: s_do_auth: auth kind: 0 2012-12-19 10:15:29 DEBUG: pid 4571: s_do_auth: backend key data received 2012-12-19 10:15:29 DEBUG: pid 4571: s_do_auth: transaction state: I