| 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: | Whole Thread | Raw Message | 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 |