strange behavior of pgbouncer

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: strange behavior of pgbouncer
Date: 2023-07-03 19:30:43
Message-ID: CA+ONtZ7wLcmoqREd2zRd0=w0hVb5zLLH=UrdLP85PX-4Aivoiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2023-07-03 19:45:20 Sanity check of shared_buffers value
Previous Message Ron 2023-07-03 12:59:39 Re: version control based configuration in Postgresql