On Mon, Jul 3, 2023 at 3:31 PM Atul Kumar <akumar14871@xxxxxxxxx> 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
