Unexpected authentication behaviour

[Domen Šetar <domen.setar@xxxxxxx>]

Hi Admins,

 

I have strange issue that I can't explain to myself:

 

I want to use scram-sha-256 authentication on postgresql 16.

Parameter password_encryption is set to scram-sha-256. I defined a user with scram-sha-256 encoded password.

My pg_hba.conf have  following  lines:

 

# TYPE  DATABASE        USER            ADDRESS                 METHOD

local      all                          all                                                          peer

host       all                          all                   samenet                     md5

 

Even though there is defined md5 authentication method for remote logins in pg_hba.conf I can make remote login to my postgresql server which is unexpected behaviour of postgresql.

What did I miss?

 

Best regards!

Domen Šetar Computer Systems Support IZUM – Institute of Information Science | Prešernova ulica 17 | 2000 Maribor | Slovenia T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si | domen.setar@xxxxxxx