> 2010/9/27 Emanuel Calvo Franco <[email protected]>: >> 2010/9/27 Tatsuo Ishii <[email protected]>: >>> You should use "raw mode", which means both replication_mode and >>> master_slave_mode are turned off. Tatsuo Ishii SRA OSS, Inc. Japan >> >> I'm using raw mode:
Ok, I'll look into this more. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp >> failover_command = 'touch /opt/WAL_ARCHIVE/pgsql.trigger' >> listen_addresses = '*' >> port = 9999 >> pcp_port = 9898 >> socket_dir = '/var/run/pgpool' >> pcp_socket_dir = '/var/run/pgpool' >> backend_socket_dir = '/var/run/pgpool' >> pcp_timeout = 10 >> num_init_children = 50 >> max_pool = 4 >> child_life_time = 300 >> connection_life_time = 0 >> child_max_connections = 0 >> client_idle_limit = 0 >> authentication_timeout = 60 >> logdir = '/var/run/postgresql' >> >> #RAW >> replication_mode = false >> master_slave_mode = false >> >> >> load_balance_mode = false >> replication_stop_on_mismatch = false >> replicate_select = false >> reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' >> print_timestamp = true >> >> connection_cache = true >> >> health_check_timeout = 20 >> health_check_period = 30 >> health_check_user = 'pgpool' >> failback_command = '' >> insert_lock = false >> ignore_leading_white_space = true >> log_statement = false >> log_connections = false >> log_hostname = false >> parallel_mode = false >> enable_query_cache = false >> >> pgpool2_hostname = 'bbdd2' >> system_db_hostname = 'bbdd1' >> system_db_port = 5432 >> system_db_dbname = 'pgpool' >> system_db_schema = 'pgpool_catalog' >> system_db_user = 'postgres' >> system_db_password = 'postavalon' >> >> backend_hostname0 = 'bbdd1' >> backend_weight0 = 1 >> backend_port0 = 5432 >> backend_hostname1 = 'bbdd2' >> #backend_weight1 = 1 >> backend_port1 = 5432 >> >> debug_level = 100 >> > > More detailed error: > > pgsql/bin/psql -p9999 -hbbdd2 -Upostgres > psql: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > In the pgpool server: > 2010-09-27 18:23:30 DEBUG: pid 23124: health_check: 0 th DB node status: 2 > 2010-09-27 18:23:30 DEBUG: pid 23124: health_check: 1 th DB node status: 2 > 2010-09-27 18:23:37 DEBUG: pid 23174: I am 23174 accept fd 6 > 2010-09-27 18:23:37 DEBUG: pid 23174: Protocol Major: 1234 Minor: 5679 > database: user: > 2010-09-27 18:23:37 DEBUG: pid 23174: SSLRequest from client > 2010-09-27 18:23:37 DEBUG: pid 23174: Protocol Major: 3 Minor: 0 > database: postgres user: postgres > 2010-09-27 18:23:37 DEBUG: pid 23174: new_connection: connecting 0 backend > 2010-09-27 18:23:37 DEBUG: pid 23174: new_connection: connecting 1 backend > 2010-09-27 18:23:37 ERROR: pid 23174: pool_read_kind: kind does not > match between master(52) slot[1] (45) > > pgpool2/bin/pcp_proc_info 2 bbdd2 9898 postgres xxxxx 23124 > BackendError > > ps f -Cpgpool > 23124 ? Ss 0:00 pgpool2/bin/pgpool -n -d > > > pgpool2/bin/pgpool --version > pgpool-II version 3.0 (umiyameboshi) > > > > > > -- > ,A ,A ,A ,A ,A ,A ,A Emanuel Calvo Franco > ,A ,A ,A ,A ,A ,A ,A ,A Independient DBA > ,A ,A ,A ,A www.emanuelcalvofranco.com.ar _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
