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

[Tatsuo Ishii]

> I launched pgpool as root so I expect that pgpool could have permission
> to write to the logdir.
> 
> My logdir was /var/run/postgresql, i changed it to /var/log/postgresql
> and finally, it works. I don't know why there is a difference with the 
> permissions.
> 
> Is it normal ?
> No explicit errors say there is problem with permissions of logdir.

Don't know. Maybe SE Linux thing? strace might show some hints...
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Thank you !
> 
> Tatsuo Ishii a écrit :
> >> 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
> >   
> 
> 
> -- 
> Germain Maurice
> Administrateur Système
> Tel : +33.(0)1.42.43.64.13
> 
> **linkfluence news & events**
> 2009 excellence award nominee from ESOMAR
> 2009 marketing research silver award from semo & marketing magazine (France)
> 2009 european excellence award recipient (PR evaluation, wahlradar.de, 
> joint project with Publicis Consultants)
> 
>