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