Re: Password authorization

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Password authorization
Date: 2022-01-21 14:10:42
Message-ID: d4fd7ed1-5dd5-7a1b-0df1-5df80cc3f0cc@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 1/20/22 09:25, Laurenz Albe wrote:
> It is not quite clear what you mean, but I assume you want password complexity rules,
> and you want to force users to change their password after a while.
>
> You cannot do any of that with passwords in the database; the best you can
> do is set an expiration time for the user's ability to log in.

Actually, you can. There is the standard "passwordcheck" module
described in the documentation:

https://www.postgresql.org/docs/current/passwordcheck.html

You would have to do some C programming, but it's very possible.

Regards

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2022-01-21 14:18:50 Re: Password authorization
Previous Message Дмитрий Иванов 2022-01-21 08:26:42 Re: Password authorization