[Pgpool-general] How to configure pgpool for pool conexions..
Matias Israel Malpica Escobar
Matias.Malpica at thyssenkrupp.com
Thu Oct 6 20:57:33 UTC 2011
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 at 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 [guillaume at 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
More information about the Pgpool-general
mailing list