-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
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
