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

Germain Maurice germain.maurice at linkfluence.net
Thu Jan 21 14:30:03 UTC 2010


Hi all,

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

Best regards,
Germain

-- 
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)



More information about the Pgpool-general mailing list