> -Original Message-
> From: pgpool-general-boun...@pgfoundry.org [mailto:pgpool-general-
> boun...@pgfoundry.org] On Behalf Of Alan Hodgson
> Sent: Thursday, October 06, 2011 5:52 PM
> To: pgpool-general@pgfoundry.org
> Subject: Re: [Pgpool-general] How to configure pgpool for pool
> conex
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
Thanks for the quick reply, mmm but i never configure the databse to open the
port , 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 Ma
If your database opens the port 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-gen
I am trying to open the database using the port (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: Mati
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:pg
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 n
2011/10/6 Guillaume Lelarge :
> On Thu, 2011-10-06 at 17:27 +0200, Olivier NOEL wrote:
>> 2011/10/6 Guillaume Lelarge :
>>
>> [...]
>>
>> >> And it's not. Ok, there is some overhead, but it's veeery slow.
>> >>
>> >
>> > How did you check that?
>> >
>> > You may be right in a specific setting, but
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 pgpoo
On Thu, 2011-10-06 at 17:27 +0200, Olivier NOEL wrote:
> 2011/10/6 Guillaume Lelarge :
>
> [...]
>
> >> And it's not. Ok, there is some overhead, but it's veeery slow.
> >>
> >
> > How did you check that?
> >
> > You may be right in a specific setting, but I have no issues getting
> > better perf
On Thu, Oct 6, 2011 at 5:27 PM, Olivier NOEL wrote:
> 2011/10/6 Guillaume Lelarge :
>
> [...]
>
> >> And it's not. Ok, there is some overhead, but it's veeery slow.
> >>
> >
> > How did you check that?
> >
> > You may be right in a specific setting, but I have no issues getting
> > better perform
On Thu, 2011-10-06 at 10:59 -0500, Matias Israel Malpica Escobar wrote:
> Hi everyone i´ve been trying to understand and configure pgpool for a pool of
> connections (not sure if that is the term), i already follow a manual and
> confiigure it like this:
>
> listen_addresses = '*'
> port =
Hi everyone i´ve been trying to understand and configure pgpool for a pool of
connections (not sure if that is the term), i already follow a manual and
confiigure it like this:
listen_addresses = '*'
port =
pcp_port = 9898
socket_dir = '/var/run/postgresql'
pcp_socket_dir = '/var/run/postgr
2011/10/6 Guillaume Lelarge :
[...]
>> And it's not. Ok, there is some overhead, but it's veeery slow.
>>
>
> How did you check that?
>
> You may be right in a specific setting, but I have no issues getting
> better performance with pgpool.
We tested our java webapp with pgpool and without pgpoo
On Thu, 2011-10-06 at 16:28 +0200, Olivier NOEL wrote:
> 2011/10/6 Guillaume Lelarge :
> > On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote:
> >> On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge
> >> wrote:
> >>
> >> > On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote:
> >> > > Hi ever
2011/10/6 Guillaume Lelarge :
> On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote:
>> On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge
>> wrote:
>>
>> > On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote:
>> > > Hi everyone,
>> > >
>> > > I'm experiencing performance issues with pgpool-3
On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote:
> On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge
> wrote:
>
> > On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote:
> > > Hi everyone,
> > >
> > > I'm experiencing performance issues with pgpool-3.1
> > > Problem is that when I connec
On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge wrote:
> On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote:
> > Hi everyone,
> >
> > I'm experiencing performance issues with pgpool-3.1
> > Problem is that when I connect through pgpool to database, database works
> > slower than
> > when I c
On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote:
> Hi everyone,
>
> I'm experiencing performance issues with pgpool-3.1
> Problem is that when I connect through pgpool to database, database works
> slower than
> when I connect directly to master. In this test case, I have disabled node2,
>
Hi everyone,
I'm experiencing performance issues with pgpool-3.1
Problem is that when I connect through pgpool to database, database works
slower than
when I connect directly to master. In this test case, I have disabled node2,
just to check performance
directly and through pgpool.
What can be a
20 matches
Mail list logo