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)

_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to