On 2020-08-21 19:49, Achilleas Mantzios wrote:
>
> On 21/8/20 7:56 μ.μ., greigwise wrote:
>> Not sure if this is the right place to post this, but if not someone please
>> point me in the right direction.
>>
>> My issue is with pgbouncer 1.14. This does not seem to happen on 1.13.
>>
>> If I do a service pgbouncer restart, then anytime I try to connect to my
>> databases via pgbouncer, I get ERROR: no such user regardless of what user
>> I'm using. It's almost like it's not recognizing the auth_query I have
>> configured. But then if I issue a reload, then it seems to work fine and I
>> no longer get the user not found. The problem is easy enough to work around
>> as I don't restart pgbouncer all that much, but it doesn't seem like this is
>> probably the intended behavior.
>
> You may go here :
> https://github.com/pgbouncer/pgbouncer/commits/pgbouncer_1_14_0
>
> and review all commits between 1.13 and 1.14
It could be related to the SCRAM pass-through.
Greig, if you have a way to reproduce it, please file a complete bug
report on GitHub.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services