> > On Fri, Apr 13, 2012 at 11:00 AM, Phoenix Kiula > <phoenix.ki...@gmail.com>wrote: > >> On Fri, Apr 13, 2012 at 2:41 AM, Scott Marlowe <scott.marl...@gmail.com> >> 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; >> >> 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
