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
>
>
Seems you already did this. I believe you are connecting as postgres user
not from root, if yes, then check .pgpass file too (it will be in postgres
user home directory).

--Raghav