Thread: strange behavior of pgbouncer
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.
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.
and when I use the same password to connect to the db directly by both users user1 and user2 , I don't get any error.
Could you help me with this? How can I troubleshoot this? Is there any way to block any particular user from connecting through pgbouncer? How to check this ?
On Mon, Jul 3, 2023 at 3:31 PM Atul Kumar <akumar14871@gmail.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