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

[Ger Apeldoorn]

Tatsuo Ishii wrote:
>> 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
>   
Hi Tatsuo,

That was it, thank you very much!

Could you perhaps add a check for this situation so it is shown in the logs?

Thanks again,
Ger.