2011/8/16 Tatsuo Ishii <is...@sraoss.co.jp>: > What operation did you do when you were getting errors below? Did you > try to connect to pgpool using psql? Or starting pgpool immediately > causes the errors?
Starting pgpool causes the errors > Also turning on debug mode of pgpool-II will give you slightly detailed info. > I suggest this if you are getting errors. here are the complete error messages : 2011-08-16 12:25:41 DEBUG: pid 1568: pool_ssl: SSL requested but SSL support is not available 2011-08-16 12:25:41 DEBUG: pid 1568: s_do_auth: auth kind: 0 2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response "E" before processing BackendKeyData 2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response "" before processing BackendKeyData 2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response "" before processing BackendKeyData 2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response "" before processing BackendKeyData 2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response "]" before processing BackendKeyData 2011-08-16 12:25:41 DEBUG: pid 1568: s_do_auth: parameter status data received 2011-08-16 12:25:41 ERROR: pid 1568: pool_read2: failed to realloc 2011-08-16 12:25:46 DEBUG: pid 1534: pool_ssl: SSL requested but SSL support is not available 2011-08-16 12:25:46 DEBUG: pid 1534: s_do_auth: auth kind: 0 2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response "E" before processing BackendKeyData 2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response "" before processing BackendKeyData 2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response "" before processing BackendKeyData 2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response "" before processing BackendKeyData 2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response "]" before processing BackendKeyData 2011-08-16 12:25:46 DEBUG: pid 1534: s_do_auth: parameter status data received 2011-08-16 12:25:46 ERROR: pid 1534: pool_read2: failed to realloc SSL is disabled on the Postgresql servers. > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp > >> Hello, >> >> I have an error with pgpool 3.0.4 in a streaming/balancing >> configuration with 1 master and 2 slaves : >> >> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown >> response "E" before processing BackendKeyData >> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown response " >> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown response " >> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown response " >> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown >> response "]" before processing BackendKeyData >> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: pool_read2: failed to realloc >> >> I followed the documentation on the website for the configuration of >> the postgresql servers and pgpool. >> >> DB servers are FreeBSD with latest Postgresql server, configured in >> streaming mode (1 master and 2 slaves), replication/failover is >> functional. >> >> The pgpool host is a Debian Wheezy with pgpooladmin. Pgpool has been >> install from packages. I have the same error without pgpooladmin. >> >> I tested installing pgpool from sources and I have the same error. >> >> I also tested pgpool on a FreeBSD box from ports and from sources, and >> same error. >> >> here is the config file : >> >> listen_addresses = '*' >> >> port = 5432 >> >> 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 = 300 >> >> connection_life_time = 0 >> >> child_max_connections = 0 >> >> client_idle_limit = 0 >> >> authentication_timeout = 60 >> >> logdir = '/tmp' >> >> pid_file_name = '/tmp/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 = 10000000 >> >> log_standby_delay = 'if_over_threshold' >> >> connection_cache = true >> >> health_check_timeout = 10 >> >> health_check_period = 20 >> >> health_check_user = 'postgres' >> >> failover_command = '/usr/local/etc/failover.sh %d "%h" %p %D %m %M "%H" %P' >> >> failback_command = '' >> >> fail_over_on_backend_error = true >> >> insert_lock = false >> >> ignore_leading_white_space = true >> >> log_statement = false >> >> log_per_node_statement = false >> >> log_connections = false >> >> log_hostname = false >> >> parallel_mode = false >> >> enable_query_cache = false >> >> pgpool2_hostname = 'pglb01' >> >> system_db_hostname = 'fpg01' >> system_db_port = 5432 >> system_db_dbname = 'pgpool' >> system_db_schema = 'pgpool_catalog' >> system_db_user = 'pgpool' >> system_db_password = 'password' >> >> >> nable_pool_hba = false >> >> recovery_user = 'postgres' >> >> recovery_password = '' >> >> recovery_1st_stage_command = 'basebackup.sh' >> >> recovery_2nd_stage_command = '' >> >> recovery_timeout = 90 >> >> client_idle_limit_in_recovery = 0 >> >> lobj_lock_table = '' >> >> ssl = false >> >> debug_level = 0 >> replication_timeout = 5000 >> backend_hostname0 = 'fpg01' >> backend_port0 = 5432 >> backend_data_directory0 = '/usr/local/pgsql/data' >> backend_weight0 = 1 >> backend_hostname1 = 'fpg02' >> backend_port1 = 5432 >> backend_data_directory1 = '/usr/local/pgsql/data' >> backend_weight1 = 2 >> backend_hostname2 = 'fpg03' >> backend_port2 = 5432 >> backend_data_directory2 = '/usr/local/pgsql/data' >> backend_weight2 = 2 >> >> -- >> Olivier >> _______________________________________________ >> Pgpool-general mailing list >> Pgpool-general@pgfoundry.org >> http://pgfoundry.org/mailman/listinfo/pgpool-general > _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general