[Pgpool-general] pgpool 2.3.x never connect to backend0

Tatsuo Ishii ishii at sraoss.co.jp
Mon Jan 25 10:19:02 UTC 2010


> It seem's to be a problem since version 2.3 of pgpool.
> 
> Pgpool never try to connect to backend0.
> If you have only one backend, pgpool answer you :
> 
> % psql -h localhost -U postgres -p 5433
> psql: server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> 
> 2010-01-21 15:25:02 LOG:   pid 29773: pgpool-II successfully started. 
> version 2.3.1 (tomiteboshi)
> 2010-01-21 15:25:02 DEBUG: pid 29797: I am PCP 29797
> 2010-01-21 15:25:08 LOG:   pid 29796: Cannot accept() new connection. 
> all backends are down
> 
> With more than one backend, the first connection is the connection to 
> backend1.
> 
> 
> I use the same pgpool.conf on the same machine between pgpool 2.2.6 and 
> 2.3.x
> 
> 
> Here is my tests :
> 
> 2.2.6, connection to backend0 is used
> 2.3, connection to backend0 is NOT used
> 2.3.1, connection to backend0 is NOT used

I could not reproduce your problem here. Does "logdir" exist and
writable by pgpool process?
--
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