Re: PGBouncer help (how to get it working)

On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:

On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Thu, Apr 12, 2012 at 11:12 AM, Phoenix Kiula <phoenix.kiula@gmail.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