Unexpected authentication behaviour

From: Domen Šetar <domen(dot)setar(at)izum(dot)si>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Unexpected authentication behaviour
Date: 2024-08-27 08:00:15
Message-ID: cf9da30891024073938cdb23be9efaf5@izum.si
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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!
[izum]

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<http://www.izum.si/> | domen(dot)setar(at)izum(dot)si<mailto:domen(dot)setar(at)izum(dot)si>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wim Bertels 2024-08-27 08:49:32 Re: Unexpected authentication behaviour
Previous Message Laurenz Albe 2024-08-27 04:37:01 Re: Function problem