> 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) > > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
