| From: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, pgbouncer-general(at)pgfoundry(dot)org |
| Subject: | Re: PGBouncer help (how to get it working) |
| Date: | 2012-04-13 05:30:21 |
| Message-ID: | CAFWfU=t5tvQWhSeji69N9uQd13TOApDWm-W95YbDRYOqnTkOTA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raghavendra | 2012-04-13 05:36:45 | Re: PGBouncer help (how to get it working) |
| Previous Message | Damian Carey | 2012-04-13 05:15:16 | Re: recommended schema diff tools? |