Re: PGBouncer help (how to get it working)

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
>