Re: PGBouncer help (how to get it working) - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: PGBouncer help (how to get it working)
Date
Msg-id CAFWfU=u8zAqSDQavYR8=p3FWQStfkRiyynfFYNrQxKwyp8zDMQ@mail.gmail.com
Whole thread Raw
In response to Re: PGBouncer help (how to get it working)  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
On Fri, Apr 13, 2012 at 2:59 PM, Raghavendra
<raghavendra.rao@enterprisedb.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?

pgsql-general by date:

Previous
From: Mike Blackwell
Date:
Subject: Re: Subselect with incorrect column not a syntax error?
Next
From: Steve Crawford
Date:
Subject: Re: Tab completion not working on OSX Lion (10.7.3)