From: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
---|---|
To: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, 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 19:03:42 |
Message-ID: | CAFWfU=u8zAqSDQavYR8=p3FWQStfkRiyynfFYNrQxKwyp8zDMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 13, 2012 at 2:59 PM, Raghavendra
<raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:
.....
>> 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).
Thanks, but this is not helping.
I have the exact same info in three files:
1. The root ".pgpass"
2. The ".pgpass" for the postgres user
3. The authfile specified inside pgbouncer -- "/var/lib/pgsql/pgbouncer.txt"
Now what?
It's not telling me that the user is unrecognized, so it's likely not
that md5 or trust or plain password issue. Pgbouncer is not even
recognizing the user!
What now?
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2012-04-13 19:04:46 | Re: Tab completion not working on OSX Lion (10.7.3) |
Previous Message | Mike Blackwell | 2012-04-13 18:40:46 | Re: Subselect with incorrect column not a syntax error? |