Re: Password settings requirements

Thank you for the clarification! The issue is that I have to check and
report the current state )). Is there any way I can check current password
settings (minimal password length for instance and maximum password
lifetime). Ideally all of the settings mentioned above ). I appreciate any
help you can provide.

Warm regards,
Agil

On Tue, Oct 19, 2021 at 4:20 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Tue, 2021-10-19 at 11:38 +0400, Agil Azimov wrote:
> >
> > On Wed, Oct 13, 2021 at 3:28 AM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > > On Tue, Oct 12, 2021 at 08:46:44PM +0400, Agil Azimov wrote:
> > > > Thank you for your message. Will I be able to set all the settings I
> mentioned
> > > > before if I will set SCRAM?
> > >
> > > No. I think you need to use PAM or something like that if you want
> > > those requirements.
> > >
> > Thank you for your reply! I would like to check the current password
> requirements of PostgreSQL server. Could you please let me know which
> command will show me the
> > 1. Minimal requirements for password length
> > 2. Maximum password age
> > 3. If the password complexity requirements are turned on.
> > 4. Password history requirement - number of passwords
> > 5. Account lockout threshold.
> >
> > I appreciate you support.
>
> As Bruce said, there are no such requirements.
> You will have to manage your passwords outside of PostgreSQL if
> you need to impose password rules.
> PAM, the pluggabla authentication mocule of Linux, is one way of doing
> that.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>