Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mcjoQ-0006S9-UU for pgsql-novice@arkaria.postgresql.org; Tue, 19 Oct 2021 07:45:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mcjoP-0006hc-Dr for pgsql-novice@arkaria.postgresql.org; Tue, 19 Oct 2021 07:45:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mcjoP-0006hT-4B for pgsql-novice@lists.postgresql.org; Tue, 19 Oct 2021 07:45:29 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mcjoM-0005Et-PU for pgsql-novice@lists.postgresql.org; Tue, 19 Oct 2021 07:45:28 +0000 Received: by mail-ed1-x52a.google.com with SMTP id y30so8457260edi.0 for ; Tue, 19 Oct 2021 00:45:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=x8tlNxJAn+gOQ1Xvw5mxDfVwFl05zSNhuGSKTOYGxEw=; b=iGlmmE98fTINTQ8weggtDanUjelAXVuJedV/m5w5i7UmWtZ2aHU9ZPk6Z/chxQ4EX9 f4weD33jDnXLc8hNne246aF72ZNDUH8E8qxLYHay/pbgDM8kja6y3XBT99De3Oh3GxSz TtoQf78BN6xvQSro5i8TIlwRruzK6HkfIZPg2ze0C5OKcCN07/b1iCc1EigIR6l7pD6J SEd/ObexjRk/ptFDqO8metATRzLfoKKCoceyizMYU3NerekZmFb9tc7/PKbmMCR6o75N EdusHYj1gZNCI0PzQ+57AJoKGtlESZTZhrW/pyjhRWHxn4pWql4S3yfAo0+LC5xmldZf G3Cg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=x8tlNxJAn+gOQ1Xvw5mxDfVwFl05zSNhuGSKTOYGxEw=; b=VDkfeeuHxu5sR/bSc92V3QzkLCTJYib/drr7AFPAbIU9S72KzskhRKUxAivvxeIwVG 0qrbtzytIODYhiBGMwi5Nx+ljyZhmmCjMiaEcjXPWkwN1kWIPN732mo+zXARU9ie2kfF U+gyBb59VLCzfpfZUFX6c5aQbS1TU2XHu1/RmboWDCi0egiyIjYJ6Vw5FY1phYdOBxA0 aRhFhuKhe9FwJahDweVZLykHoVinbRUuhekzq2JtJxtAbSSmVsod8rS7Np8ySsgzPnSV 9/kQlQxL7heX/1bL8prj+/4C2XEy7Rzi5EvlPL+OkuBw9A8TNb1gb3FRi70dXZtxyNmo 9jfw== X-Gm-Message-State: AOAM5330z8MgFyWrY50PEC8IJV0GuQkUHg+Rj0EQsi8iwbFQ3fMecj/C IL5dn1CTy+pMXG3F6gIXIZT5LTbrG3mYXQo+xF0= X-Google-Smtp-Source: ABdhPJzGKpXs5I3Qs4ZSf8JGnIBUHUkPBqLdCl8DWvkoNHPz44UZ0FEJOw+qhnPWKfk9J2pgTQ/Bek/vXV4SLAszCQc= X-Received: by 2002:a05:6402:5249:: with SMTP id t9mr51798378edd.135.1634629524771; Tue, 19 Oct 2021 00:45:24 -0700 (PDT) MIME-Version: 1.0 References: <577837.1634054018@sss.pgh.pa.us> <20211012232823.GA2342@momjian.us> In-Reply-To: From: Agil Azimov Date: Tue, 19 Oct 2021 11:45:13 +0400 Message-ID: Subject: Re: Password settings requirements To: Bruce Momjian Cc: Tom Lane , pgsql-novice@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000029dc1005ceafd864" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000029dc1005ceafd864 Content-Type: text/plain; charset="UTF-8" I know that the authentication md5 is used . On Tue, Oct 19, 2021 at 11:38 AM Agil Azimov wrote: > 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. > > On Wed, Oct 13, 2021 at 3:28 AM Bruce Momjian 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. >> >> -- >> Bruce Momjian https://momjian.us >> EDB https://enterprisedb.com >> >> If only the physical world exists, free will is an illusion. >> >> --00000000000029dc1005ceafd864 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I know that the authentication md5 is used .=C2=A0=C2=A0
On= Tue, Oct 19, 2021 at 11:38 AM Agil Azimov <agil.azimov@gmail.com> wrote:
Thank you for your reply= ! I would like to check the current password requirements of PostgreSQL ser= ver. 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.=C2=A0<= /div>
4. Password history requirement - number of passwords
5= .=C2=A0Account lockout threshold.

I appreciate you= support.

On Wed, Oct 13, 2021 at 3:28 AM Bruce Momjian <bruce@momjian.us> wro= te:
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 m= entioned
> before if I will set SCRAM?

No.=C2=A0 I think you need to use PAM or something like that if you want those requirements.

--
=C2=A0 Bruce Momjian=C2=A0 <bruce@momjian.us>=C2=A0 =C2=A0 =C2=A0 =C2=A0 https://momjian.us=
=C2=A0 EDB=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 https:= //enterprisedb.com

=C2=A0 If only the physical world exists, free will is an illusion.

--00000000000029dc1005ceafd864--