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

[Asaf Ohaion]

sorry, looking at postgres logs I saw that
pgpool couldn't connect to 'localhost' because of
pg_hba issue

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


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