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

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jan 26 14:03:11 UTC 2010


> I'm still having this issue, pgpool-II cannot connect to the backends 
> after upgrading to version 2.3.
> The other pgpool (which connects to the same backend servers and runs 
> the same pgpool version with identical configuration) does connect.
> 
> If I become user postgres, I can 'psql' into the backends manually 
> without any problems. Thus, it is not a connectivity issue.
> 
> Could it be that only one pgpool-II server can be active at the same time?
> 
> I've attached debugging info, perhaps this sheds some light to the problem.

Do you have "pgpool_status" file under /tmp? I suspect you have stale
one. Can you stop pgpool, remove the file and start pgpool?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the Pgpool-general mailing list