Hi, Could you show us PostgreSQL log?
Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] From: Andrei <[EMAIL PROTECTED]> Subject: [Pgpool-general] connection problem Date: Mon, 14 Jan 2008 04:00:54 -0800 (PST) > I am new to pgpool and I tried to replicate a database like in the tutorial > in the documentation and I ran into a bit of a problem > I run > -bash-3.2$ psql -p 9999 > > when i try to connect i get this > > psql: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > in the server log i get > > 2008-01-14 13:53:22 LOG: pid 25311: connection received: host=[local] > 2008-01-14 13:53:22 DEBUG: pid 25311: Protocol Major: 3 Minor: 0 database: > postgres user: postgres > 2008-01-14 13:53:22 DEBUG: pid 25311: new_connection: connecting 0 backend > 2008-01-14 13:53:22 DEBUG: pid 25311: new_connection: connecting 1 backend > 2008-01-14 13:53:22 DEBUG: pid 25311: new_connection: connecting 2 backend > 2008-01-14 13:53:22 LOG: pid 25311: pool_do_auth: maybe protocol version > mismatch (current version 3) > 2008-01-14 13:53:22 DEBUG: pid 25311: pool_read_string: read all from pending > data. po:1 len:121 > 2008-01-14 13:53:22 DEBUG: pid 25311: pool_read_string: read all from pending > data. po:1 len:121 > 2008-01-14 13:53:22 DEBUG: pid 25311: pool_read_string: read all from pending > data. po:1 len:121 > > > my pgpool.conf looks like this > > # > # pgpool-II configuration file sample > # $Header: /cvsroot/pgpool/pgpool-II/pgpool.conf.sample,v 1.15 2007/10/31 > 10:45:52 y-asaba Exp $ > > # Host name or IP address to listen on: '*' for all, '' for no TCP/IP > # connections > listen_addresses = 'localhost' > > # Port number for pgpool > port = 9999 > > # Port number for pgpool communication manager > pcp_port = 9898 > > # Unix domain socket path. (The Debian package defaults to > # /var/run/postgresql.) > socket_dir = '/tmp' > > # Unix domain socket path for pgpool communication manager. > # (Debian package defaults to /var/run/postgresql) > pcp_socket_dir = '/tmp' > > # Unix domain socket path for the backend. Debian package defaults to > /var/run/postgresql! > backend_socket_dir = '/tmp' > > # pgpool communication manager timeout. 0 means no timeout, but strongly not > recommended! > pcp_timeout = 10 > > # number of pre-forked child process > num_init_children = 32 > > # Number of connection pools allowed for a child process > max_pool = 4 > > # If idle for this many seconds, child exits. 0 means no timeout. > child_life_time = 300 > > # If idle for this many seconds, connection to PostgreSQL closes. > # 0 means no timeout. > connection_life_time = 0 > > # If child_max_connections connections were received, child exits. > # 0 means no exit. > child_max_connections = 0 > > # If client_idle_limit is n (n > 0), the client is forced to be > # disconnected whenever after n seconds idle (even inside an explicit > # transactions!) > # 0 means no disconnect. > client_idle_limit = 0 > > # Maximum time in seconds to complete client authentication. > # 0 means no timeout. > authentication_timeout = 60 > > # Logging directory > logdir = '/tmp' > > # Replication mode > replication_mode = true > > # Set this to nonzero (in milliseconds) to detect this situation and > # resolve the deadlock by aborting current session. > replication_timeout = 5000 > > # Load balancing mode, i.e., all SELECTs except in a transaction block > # are load balanced. This is ignored if replication_mode is false. > load_balance_mode = true > > # if there's a data mismatch between master and secondary > # start degeneration to stop replication mode > replication_stop_on_mismatch = true > > # If true, replicate SELECT statement when load balancing is disabled. > # If false, it is only sent to the master node. > replicate_select = false > > # Semicolon separated list of queries to be issued at the end of a session > reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' > > # If true print timestamp on each log line. > print_timestamp = true > > # If true, operate in master/slave mode. > master_slave_mode = false > > # If true, cache connection pool. > connection_cache = true > > # Health check timeout. 0 means no timeout. > health_check_timeout = 20 > > # Health check period. 0 means no health check. > health_check_period = 0 > > # Health check user > health_check_user = 'nobody' > > # Execute command by failover. > # special values: %d = node id > # %h = host name > # %p = port number > # %D = database cluster path > # %% = '%' character > # > failover_command = '' > > # Execute command by failback. > # special values: %d = node id > # %h = host name > # %p = port number > # %D = database cluster path > # %% = '%' character > # > failback_command = '' > > # If true, automatically lock table with INSERT statements to keep SERIAL > # data consistency. An /*INSERT LOCK*/ comment has the same effect. A > # /NO INSERT LOCK*/ comment disables the effect. > insert_lock = false > > # If true, ignore leading white spaces of each query while pgpool judges > # whether the query is a SELECT so that it can be load balanced. This > # is useful for certain APIs such as DBI/DBD which is known to adding an > # extra leading white space. > ignore_leading_white_space = true > > # If true, print all statements to the log. Like the log_statement option > # to PostgreSQL, this allows for observing queries without engaging in full > # debugging. > log_statement = false > > # If true, incoming connections will be printed to the log. > log_connections = true > > # If true, hostname will be shown in ps status. Also shown in > # connection log if log_connections = true. > # Be warned that this feature will add overhead to look up hostname. > log_hostname = false > > # if non 0, run in parallel query mode > parallel_mode = false > > # if non 0, use query cache > enable_query_cache = false > > #set pgpool2 hostname > pgpool2_hostname = '' > > # system DB info > system_db_hostname = 'localhost' > system_db_port = 5432 > system_db_dbname = 'pgpool' > system_db_schema = 'pgpool_catalog' > system_db_user = 'pgpool' > system_db_password = '' > > # backend_hostname, backend_port, backend_weight > # here are examples > backend_hostname0 = 'localhost' > backend_port0 = 5432 > backend_weight0 = 1 > backend_data_directory0 = '/data' > backend_hostname1 = 'localhost' > backend_port1 = 5433 > backend_weight1 = 1 > backend_data_directory1 = '/data1' > backend_hostname2 = 'localhost' > backend_port2 = 5434 > backend_weight2 = 1 > backend_data_directory2 = '/data2' > > > # - HBA - > > # If true, use pool_hba.conf for client authentication. In pgpool-II > # 1.1, the default value is false. The default value will be true in > # 1.2. > enable_pool_hba = false > > # - online recovery - > # online recovery user > recovery_user = 'nobody' > > # online recovery password > recovery_password = '' > > # execute a command in first stage. > recovery_1st_stage_command = '' > > # execute a command in second stage. > recovery_2nd_stage_command = '' > > > --------------------------------- > Never miss a thing. Make Yahoo your homepage. _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
