Thanks for the quick reply, mmm but i never configure the databse to open the port 9999, would it help if i copy my pgpool.config file?
________________________________________ De: Jose Mendoza [jose.mend...@autonomy.com] Enviado el: jueves, 06 de octubre de 2011 04:47 p.m. Para: Matias Israel Malpica Escobar CC: pgpool-general@pgfoundry.org Asunto: RE: [Pgpool-general] How to configure pgpool for pool conexions.. If your database opens the port 9999 then pgpool finds it in use when it starts. Jose Autonomy Ops verificare tua hinc -----Original Message----- From: Matias Israel Malpica Escobar [mailto:matias.malp...@thyssenkrupp.com] Sent: Thursday, October 06, 2011 2:39 PM To: Jose Mendoza Cc: pgpool-general@pgfoundry.org Subject: RE: [Pgpool-general] How to configure pgpool for pool conexions.. I am trying to open the database using the port 9999 (pgpool port), let me know if that answers your question.. I am restarting services anyway... ________________________________________ De: Jose Mendoza [jose.mend...@autonomy.com] Enviado el: jueves, 06 de octubre de 2011 04:39 p.m. Para: Matias Israel Malpica Escobar; Guillaume Lelarge CC: pgpool-general Asunto: RE: [Pgpool-general] How to configure pgpool for pool conexions.. What is opening the port pgpool or the database? Sometimes I found out that postgres opens the port and have to stop pgpool and postgres and restart postgrsql and pgpool again. Jose Autonomy Ops verificare tua hinc -----Original Message----- From: pgpool-general-boun...@pgfoundry.org [mailto:pgpool-general-boun...@pgfoundry.org] On Behalf Of Matias Israel Malpica Escobar Sent: Thursday, October 06, 2011 1:58 PM To: Guillaume Lelarge Cc: pgpool-general Subject: Re: [Pgpool-general] How to configure pgpool for pool conexions.. Another question for you guys... I have succesfully installed and configure pgpool, if i go to pgadmin and connect to port 9999 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 9999 psql: could not connect to server: Connection refused Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.9999"? [root@ etc]# The database is actually on the same server, and i have checked the iptables and the port is open... PG_HBA is also reflecting that i can permit conections to UNIX conection... What i am doing wrng???? ________________________________________ De: Guillaume Lelarge [guilla...@lelarge.info] Enviado el: jueves, 06 de octubre de 2011 11:25 a.m. Para: Matias Israel Malpica Escobar CC: pgpool-general Asunto: RE: [Pgpool-general] How to configure pgpool for pool conexions.. On Thu, 2011-10-06 at 11:13 -0500, Matias Israel Malpica Escobar wrote: > Hi thanks for your answers, what i wanted to say about the connections and errors from pgpool was that, for what i understand postgres returns an error if the number of connections are higher than its maximum, and pgpool puts the remaining connections in a queue is that right? I am actually doing it with the configuration that i have? Is there any way to test it? > Yes, that's right. You don't get error message telling you the usual FATAL message about max_connections. I don't know a quick way to test it. Perhaps with pgbench and a number of clients a bit higher than the max_connections of PostgreSQL? I would first try that. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general