public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Agil Azimov <[email protected]>
To: Bruce Momjian <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: [email protected]
Subject: Re: Password settings requirements
Date: Tue, 19 Oct 2021 14:20:01 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEQStSvQqubp3xOTinVtkgaEM=1-h0GrYAbYA_saX_Dot68mvA@mail.gmail.com>
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>

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

* 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