public inbox for [email protected]  

help / color / mirror / Atom feed

From: Agil Azimov <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: [email protected]
Subject: Re: Password settings requirements
Date: Tue, 19 Oct 2021 17:01:54 +0400
Message-ID: <CAEQStSsqiCb_ROOrD5PkAwDG8jbOWwfpsK9VDVMwRit6WoUSmA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAEQStStkY7Hg-MhUnfbn1wMQGzM88uSQ=bLs3BPxGn_WCOmBjA@mail.gmail.com>
	<[email protected]>
	<CAEQStSu8v2C8sJcMxk_h=9Kq=Ano0T8kXg6a0L9iOZ8UTVpwBQ@mail.gmail.com>
	<[email protected]>
	<CAEQStSvQqubp3xOTinVtkgaEM=1-h0GrYAbYA_saX_Dot68mvA@mail.gmail.com>
	<[email protected]>

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 <[email protected]>
wrote:

> On Tue, 2021-10-19 at 11:38 +0400, Agil Azimov wrote:
> >
> > On Wed, Oct 13, 2021 at 3:28 AM Bruce Momjian <[email protected]> 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
>
>

view thread (12+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Password settings requirements
  In-Reply-To: <CAEQStSsqiCb_ROOrD5PkAwDG8jbOWwfpsK9VDVMwRit6WoUSmA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox