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 --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
