[Pgpool-general] psql : "server closed the connection unexpectedly"

[Asaf Ohaion]

tried using 2.3.22 or 2.3.3

LOG:

2010-05-11 06:52:12 DEBUG: pid 4348: I am 4348
2010-05-11 06:52:12 DEBUG: pid 4349: I am 4349
2010-05-11 06:52:12 DEBUG: pid 4350: I am 4350
2010-05-11 06:52:12 DEBUG: pid 4351: I am 4351
2010-05-11 06:52:12 DEBUG: pid 4352: I am 4352
2010-05-11 06:52:12 DEBUG: pid 4353: I am 4353
2010-05-11 06:52:12 DEBUG: pid 4354: I am 4354
2010-05-11 06:52:12 DEBUG: pid 4355: I am 4355
2010-05-11 06:52:12 LOG:   pid 4281: pgpool-II successfully started.
version 2.3.2.2 (tomiteboshi)
2010-05-11 06:52:12 DEBUG: pid 4356: I am PCP 4356

2010-05-11 06:52:26 DEBUG: pid 4355: I am 4355 accept fd 5
2010-05-11 06:52:26 DEBUG: pid 4355: Protocol Major: 3 Minor: 0 database:
postgres user: postgres
2010-05-11 06:52:26 DEBUG: pid 4355: new_connection: connecting 0 backend
2010-05-11 06:52:26 DEBUG: pid 4355: new_connection: connecting 1 backend
2010-05-11 06:52:26 DEBUG: pid 4355: new_connection: skipping slot 1
because backend_status = 3
2010-05-11 06:52:26 DEBUG: pid 4355: pool_ssl: SSL requested but SSL
support is not available
2010-05-11 06:52:26 LOG:   pid 4355: pool_do_auth: maybe protocol version
mismatch (current version 3)
2010-05-11 06:52:26 DEBUG: pid 4355: pool_read_string: read all from
pending data. po:1 len:93

CONF:

# Host name or IP address to listen on: '*' for all, '' for no TCP/IP
# connections
listen_addresses = '*'

# Port number for pgpool
port = 5432

# 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'


...default from sample..

# Replication mode
replication_mode = true

# Load balancing mode, i.e., all SELECTs are load balanced.
# This is ignored if replication_mode is false.
load_balance_mode = false

# if there's a data mismatch between master and secondary
# start degeneration to stop replication mode
replication_stop_on_mismatch = false

# If true, replicate SELECT statement when load balancing is disabled.
# If false, it is only sent to the master node.
replicate_select = false

..default..

# 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 = 9999
backend_weight0 = 1
backend_data_directory0 = '/var/lib/pgsql/data'
backend_hostname1 = 'the.other.server.ip'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/var/lib/pgsql/data'

...
..

-- 
Asaf Ohaion
Lingnu Open Source Consulting Ltd
09-7655871 (204), 0547-920828
http://www.lingnu.com