From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
---|---|
To: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, pgbouncer-general(at)pgfoundry(dot)org |
Subject: | Re: PGBouncer help (how to get it working) |
Date: | 2012-04-13 05:36:45 |
Message-ID: | CA+h6AhjS=+wpuu7u=iGMvgsi2gj+wVoo+Mxay-xPCXmvrm+N8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>wrote:
> On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> wrote:
> > On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
> 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 try again.
>
>
> I had already done this. Doesn't do anything. Pgbouncer starts
> (service pgbouncer restart) but when I try to connect, it tells me
>
> psql: ERROR: No such user: MYSITE_pgbouncer
>
> Where should i create the "MYSITE_pgbouncer" user?
>
>
Add it in pgbouncer.auth file.... as per your .ini file parameter.
auth_file = /var/lib/pgsql/pgbouncer.txt
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Raghavendra | 2012-04-13 05:59:36 | Re: PGBouncer help (how to get it working) |
Previous Message | Phoenix Kiula | 2012-04-13 05:30:21 | Re: PGBouncer help (how to get it working) |