That is the correct output. I think, pgpool must be running fine. Did you check your processes after this? What options do you give while starting pgpool? Use "pgpool -d -D -f pgpool.conf".
________________________________ From: Bharath Keshav <[email protected]> To: [email protected] Sent: Thu, February 3, 2011 2:32:21 PM Subject: [Pgpool-general] stuck with a shmem_exit after the loading of "/usr/local/etc/pool_hba.conf" I am getting the following error when I try to run Pgpool. I am trying to use postgresql 9.0 hot streaming and then load balancing capability of Pgpool. However, I am stuck with a shmem_exit after the loading of "/usr/local/etc/pool_hba.conf", as attached below. Please let me know what could be wrong. 2011-02-03 08:53:20 DEBUG: pid 12138: key: listen_addresses 2011-02-03 08:53:20 DEBUG: pid 12138: value: '*' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: port 2011-02-03 08:53:20 DEBUG: pid 12138: value: 9999 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: pcp_port 2011-02-03 08:53:20 DEBUG: pid 12138: value: 9898 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: socket_dir 2011-02-03 08:53:20 DEBUG: pid 12138: value: '/var/run/postgresql' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: pcp_socket_dir 2011-02-03 08:53:20 DEBUG: pid 12138: value: '/tmp' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: backend_socket_dir 2011-02-03 08:53:20 DEBUG: pid 12138: value: '/var/run/postgresql' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: pcp_timeout 2011-02-03 08:53:20 DEBUG: pid 12138: value: 10 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: num_init_children 2011-02-03 08:53:20 DEBUG: pid 12138: value: 32 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: max_pool 2011-02-03 08:53:20 DEBUG: pid 12138: value: 4 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: child_life_time 2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: connection_life_time 2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: child_max_connections 2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: client_idle_limit 2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: authentication_timeout 2011-02-03 08:53:20 DEBUG: pid 12138: value: 60 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: logdir 2011-02-03 08:53:20 DEBUG: pid 12138: value: '/var/log/pgpool' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: pid_file_name 2011-02-03 08:53:20 DEBUG: pid 12138: value: '/var/run/pgpool/pgpool.pid' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: replication_mode 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: load_balance_mode 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: replication_stop_on_mismatch 2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: replication_stop_on_mismatch: 0 2011-02-03 08:53:20 DEBUG: pid 12138: key: failover_if_affected_tuples_mismatch 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: failover_if_affected_tuples_mismatch: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: replicate_select 2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: replicate_select: 0 2011-02-03 08:53:20 DEBUG: pid 12138: key: reset_query_list 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'ABORT;DISCARD ALL' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: ABORT 2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: DISCARD ALL 2011-02-03 08:53:20 DEBUG: pid 12138: key: white_function_list 2011-02-03 08:53:20 DEBUG: pid 12138: value: '' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: black_function_list 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'nextval,setval,foo' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: nextval 2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: setval 2011-02-03 08:53:20 DEBUG: pid 12138: extract_string_tokens: token: foo 2011-02-03 08:53:20 DEBUG: pid 12138: key: print_timestamp 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: master_slave_mode 2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: master_slave_sub_mode 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'stream' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: delay_threshold 2011-02-03 08:53:20 DEBUG: pid 12138: value: 100 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: log_standby_delay 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'if_over_threshold' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: connection_cache 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: health_check_timeout 2011-02-03 08:53:20 DEBUG: pid 12138: value: 10 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: health_check_period 2011-02-03 08:53:20 DEBUG: pid 12138: value: 10 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: health_check_user 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'www-data' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: failover_command 2011-02-03 08:53:20 DEBUG: pid 12138: value: '/usr/local/etc/failover.sh %d "%h" %p %D %m %M "%H" %P' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: failback_command 2011-02-03 08:53:20 DEBUG: pid 12138: value: '/bin/rm -f /tmp/trigger_file1' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: fail_over_on_backend_error 2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: insert_lock 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: ignore_leading_white_space 2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: log_statement 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: log_per_node_statement 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: log_connections 2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: log_hostname 2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: parallel_mode 2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: enable_query_cache 2011-02-03 08:53:20 DEBUG: pid 12138: value: false kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: pgpool2_hostname 2011-02-03 08:53:20 DEBUG: pid 12138: value: '67.23.26.182' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_hostname 2011-02-03 08:53:20 DEBUG: pid 12138: value: '67.23.26.182' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_port 2011-02-03 08:53:20 DEBUG: pid 12138: value: 5432 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_dbname 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpool' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_schema 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpool_catalog' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_user 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpool' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: system_db_password 2011-02-03 08:53:20 DEBUG: pid 12138: value: '' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: enable_pool_hba 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: pool_passwd 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pool_passwd' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_user 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'postgres' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_password 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpoolAdmin' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_1st_stage_command 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'basebackup.sh' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_2nd_stage_command 2011-02-03 08:53:20 DEBUG: pid 12138: value: '' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: recovery_timeout 2011-02-03 08:53:20 DEBUG: pid 12138: value: 60 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: client_idle_limit_in_recovery 2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: key: lobj_lock_table 2011-02-03 08:53:20 DEBUG: pid 12138: value: 'pgpool_lobj_lock' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: ssl 2011-02-03 08:53:20 DEBUG: pid 12138: value: true kind: 1 2011-02-03 08:53:20 DEBUG: pid 12138: key: ssl_key 2011-02-03 08:53:20 DEBUG: pid 12138: value: '/usr/local/etc/server.key' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: ssl_cert 2011-02-03 08:53:20 DEBUG: pid 12138: value: '/usr/local/etc/server.crt' kind: 4 2011-02-03 08:53:20 DEBUG: pid 12138: key: debug_level 2011-02-03 08:53:20 DEBUG: pid 12138: value: 0 kind: 2 2011-02-03 08:53:20 DEBUG: pid 12138: loading "/usr/local/etc/pool_hba.conf" for client authentication configuration file 2011-02-03 08:53:20 DEBUG: pid 12138: shmem_exit(0) thanks, Bharath
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
