From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | Atul Kumar <akumar14871(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: strange behavior of pgbouncer |
Date: | 2023-07-03 22:01:55 |
Message-ID: | CAMkU=1yfVeo-m7uLRpOZ42BqicaeUw7-seWPuHAdx3zTX+VcTQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, Jul 3, 2023 at 3:31 PM Atul Kumar <akumar14871(at)gmail(dot)com> wrote:
> Hi,
>
> I am using pgbouncer 1.16 that is installed on host A and users are
> connecting through pgbouncer on host A to connect to the postgres database
> that is installed on host B. Postgres db version is 12 and both hosts are
> running on Centos 7 OS.
>
> I have 2 users in userlist.txt file user1 and user2. Both users have the
> same passwords.
>
What is your auth_type? Do you have an auth_query?
> Through Pgbouncer, if I connect through user1 I get an error message of
> "password authentication failed", but I don't get this error while I
> connect through user2, although the "passwords are the same" and Previously
> both users were working fine.
>
> I don't know what happened that caused that error.
>
> I checked pgbouncer and db logs both but both log files have the
> same issue i.e. password authentication failed for user1 while I try to
> connect through pgbouncer using user1.
>
On the server, it always gives additional info (probably as DETAIL lines)
when there is a password failure. What is that info?
Cheers,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | jacob ndinkwa | 2023-07-05 13:28:31 | Re: Sanity check of shared_buffers value |
Previous Message | Ron | 2023-07-03 20:45:48 | Re: Sanity check of shared_buffers value |