-general@postgresql.org
Subject: Re: [GENERAL] Pgbouncer help
On 08/27/2013 10:40 AM, Jeff Janes wrote:
> On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
> wrote:
>> HI
>>
>>
>>
>> In our current project, we are opening several postgresql connection.
&g
---
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: Tuesday, August 27, 2013 11:10 PM
To: Yelai, Ramkumar IN BLR STS
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pgbouncer help
On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
wrote:
> HI
>
>
>
> In our current project
On 08/27/2013 10:40 AM, Jeff Janes wrote:
On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
wrote:
HI
In our current project, we are opening several postgresql connection. Few
connections are frequently used and few are occasionally used. Hence we plan
to adapt connection pool meth
On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
wrote:
> HI
>
>
>
> In our current project, we are opening several postgresql connection. Few
> connections are frequently used and few are occasionally used. Hence we plan
> to adapt connection pool method to avoid more connection to ope
HI
In our current project, we are opening several postgresql connection. Few
connections are frequently used and few are occasionally used. Hence we plan to
adapt connection pool method to avoid more connection to open. We plan to use
"Pgbouncer". Most of the pgbouncer example shows how to
On Sat, Apr 14, 2012 at 6:35 PM, Clodoaldo Neto <
clodoaldo.pinto.n...@gmail.com> wrote:
> Em 14 de abril de 2012 09:39, raghu ram escreveu:
>
>>
>>
>> On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto <
>> clodoaldo.pinto.n...@gmail.com> wrote:
>>
>>> Em 12 de abril de 2012 14:12, Phoenix Kiula
>>
Em 14 de abril de 2012 09:39, raghu ram escreveu:
>
>
> On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto <
> clodoaldo.pinto.n...@gmail.com> wrote:
>
>> Em 12 de abril de 2012 14:12, Phoenix Kiula
>> escreveu:
>>
>>> I had pgbouncer working somehow, but we have switched servers recently
>>> and n
On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto <
clodoaldo.pinto.n...@gmail.com> wrote:
> Em 12 de abril de 2012 14:12, Phoenix Kiula escreveu:
>
>> I had pgbouncer working somehow, but we have switched servers recently
>> and now I cannot for the life of me figure out again how to set it up.
>>
Em 12 de abril de 2012 14:12, Phoenix Kiula escreveu:
> I had pgbouncer working somehow, but we have switched servers recently
> and now I cannot for the life of me figure out again how to set it up.
>
> Online guides say things like "create a user ID". Well, where? Inside
> PG the database? Or i
On Fri, Apr 13, 2012 at 2:59 PM, Raghavendra
wrote:
.
>> Add it in pgbouncer.auth file as per your .ini file parameter.
>>
>> auth_file = /var/lib/pgsql/pgbouncer.txt
>>
>
> Seems you already did this. I believe you are connecting as postgres user
> not from root, if yes, then check .
>
> On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula
> wrote:
>
>> On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe
>> wrote:
>> > On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula <
>> phoenix.ki...@gmail.com> wrote:
>> >>
>> >> WARNING: password file "/root/.pgpass" has group or world access;
>> >
On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula wrote:
> On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe
> wrote:
> > On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula
> wrote:
> >>
> >> WARNING: password file "/root/.pgpass" has group or world access;
> >> permissions should be u=rw (0600) or
On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe wrote:
> On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula
> wrote:
>>
>> WARNING: password file "/root/.pgpass" has group or world access;
>> permissions should be u=rw (0600) or less
>> psql: ERROR: No such user: MYSITE_pgbouncer
>
> Pretty s
On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula wrote:
>
> WARNING: password file "/root/.pgpass" has group or world access;
> permissions should be u=rw (0600) or less
> psql: ERROR: No such user: MYSITE_pgbouncer
Pretty sure the error is just the perms on that file. Set them to
0600 and
I had pgbouncer working somehow, but we have switched servers recently
and now I cannot for the life of me figure out again how to set it up.
Online guides say things like "create a user ID". Well, where? Inside
PG the database? Or in my CentOS system?
Here's my "/etc/pgbouncer.ini":
[datab
15 matches
Mail list logo
