Re: [Pgpool-general] How to configure pgpool for pool conexions..
On October 6, 2011 02:44:34 PM Matias Israel Malpica Escobar wrote: Another question for you guys... I have succesfully installed and configure pgpool, if i go to pgadmin and connect to port of my server i can see the databases and everything... but when i try to run the following i get this error: [root@etc]# psql -d test -U testuser -p psql: could not connect to server: Connection refused Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.? [root@ etc]# What is socket_dir set to in pgpool.conf? If it isn't /tmp, then psql will need a hint how to find the unix domain socket to talk to. ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
[Pgpool-general] pgpool-II 3.0 and 3.0.1 - backend processes stuck in PARSE
I upgraded a busy pgpool-II instance to 3.0 last week and very quickly had to back it out to 2.3.3 due to this issue. I tried 3.0.1 today and it does the same thing. Certain queries seem to be causing the backend to remain in the PARSE state. The pgpool process itself leaves the socket open and opens new ones, doing additional work. Eventually the backend runs out of available processes and everything comes to a halt. The backend servers in this case are running PostgreSQL 8.3.11 on Linux. Mostly I'm wondering if this is a known issue and if there's a knob somewhere that can fix it. I don't see anything in the archives about it though. Thanks for any assistance. ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general