[Pgpool-general] How to configure pgpool for pool conexions..

[Matias Israel Malpica Escobar]

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.mendoza at autonomy.com]
Enviado el: jueves, 06 de octubre de 2011 04:47 p.m.
Para: Matias Israel Malpica Escobar
CC: pgpool-general at 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.Malpica at thyssenkrupp.com]
Sent: Thursday, October 06, 2011 2:39 PM
To: Jose Mendoza
Cc: pgpool-general at 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.mendoza at 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-bounces at pgfoundry.org
[mailto:pgpool-general-bounces at 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 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
_______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general