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 ?
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 |