[Pgpool-general] pgpool transport endpoint connection error

[Tatsuo Ishii]

> Hi,
> 
> After searching the forum archives, I came across another post which had the
> same error message I am having:
> 
> http://ml.postgresql.jp/pipermail/pgsql-jp/2004-February/015725.html

Problem described above is not relevant to yours since they didn't use
pgpool.

Besides that I'm not sure what your problem is coming from, though I
suspect your PostgreSQL's max_connections is lower than
num_init_children * (# of user/database pairs of your pgpool clients).
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> My error message reads as:
> 
> SQLSTATE[08006] [7] could not send startup packet: Transport endpoint is not
> connected
> 
> # pgpool -h
> pgpool version 3.2(kawakawa),
>   a generic connection pool/replication/load balance server for PostgreSQL
> 
> My config:
> 
> listen_addresses = 'localhost'
> port = 5434
> socket_dir = '/tmp'
> backend_host_name = ''
> backend_port = 5432
> backend_socket_dir = '/tmp'
> secondary_backend_host_name = ''
> secondary_backend_port = 0
> num_init_children = 128
> max_pool = 16
> child_life_time = 0
> connection_life_time = 15
> child_max_connections = 0
> logdir = '/var/run'
> replication_mode = false
> connection_cache = true
> health_check_timeout = 20
> health_check_period = 0
> health_check_user = 'nobody'
> insert_lock = false
> ignore_leading_white_space = false
> 
> 
> I have about 170 open connections when it starts giving me the error message
> on connect. Any ideas?
> 
> TIA