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 1maKsX-0008N2-Nr for pgsql-novice@arkaria.postgresql.org; Tue, 12 Oct 2021 16:43:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maKsV-0008Us-4g for pgsql-novice@arkaria.postgresql.org; Tue, 12 Oct 2021 16:43:47 +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 1maKsU-0008Uk-S4 for pgsql-novice@lists.postgresql.org; Tue, 12 Oct 2021 16:43:46 +0000 Received: from mail-ed1-x535.google.com ([2a00:1450:4864:20::535]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1maKsS-00072c-DL for pgsql-novice@lists.postgresql.org; Tue, 12 Oct 2021 16:43:45 +0000 Received: by mail-ed1-x535.google.com with SMTP id g8so1869939edt.7 for ; Tue, 12 Oct 2021 09:43:44 -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=0OMCCb5Di/5rAWy3aDeVptPETFdiGf4Zzk2V8j2puIU=; b=IcciRFG4u941PcHZFITAynGf34lqg3ClV7rQ5pmhzUQSSa+DMluTD8sfvPGC+lvboc Cejz3tIqUXzEQ4oCZIDFcb2Vaxt3ccVh1fkVfe6gG9OQQtAP6BEphOfI8twj+vvd4qfP dUmfdcPDhOiwaGaG5IpQWFK17B2m32InxphJj9S9JYqDNwmMRQoytLthuEeIFPsRoRff FCbjqTHAn9xOhWRIwNmndnoZ9pUy0TGDaw9F95mpy/SVTVgXmO/IPncZ/KTAxxVChypK CVwNMcFNwKl5A7ryl1qROyMeF89lRPPifMXXWOxLwpjKuLWBIQipwnI6fJjCtEn2YlCg ltjQ== 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=0OMCCb5Di/5rAWy3aDeVptPETFdiGf4Zzk2V8j2puIU=; b=FC1t2pxXzz1xlFqPkN36hmPkPxSCnt++eovR9TPB+95PeuPXwMNpFlmYc7QyQaElYi 7Nz170r5/Dh+oDKMHJSFeU6bE3QV4uNAT6VacUD/dT1f68AHa1xDL9qFQPtwKDs0QALG X4AczwauSkFez4sM4xAXLB5ZZAIsEiVwluOY5IqJBJUuUYqeSjmkJ6S+7/tQ4MSS8YFR LFr6aI+bGu82pcbMmjgFW/H256ZW6wIqNSjR3s9536uPVZMRuHt9Ay4MXiOyxI5TKN9y x2N4mJn5WGRaMROV6EwITkXvpNyEvlyT0QgPVTuQkCG3JuttXvh9f+wlYUXrs3uByHKH EuuQ== X-Gm-Message-State: AOAM533uHs3wUGAEY3zS5sG34VP6KweyDjfgA80Kkj522ec8780u7DAt NjGG0t5VeLEOFU7xWxhN7g1zm2Mdao3UJxCZN8A= X-Google-Smtp-Source: ABdhPJxeAE/KEmhC4ggu793/Ixg7khTiFLnashQ7pgCwm/HOlnvACnvXN84MRVbG8Tl0fdox87NgaLv1vaNh5ui621w= X-Received: by 2002:a05:6402:348d:: with SMTP id v13mr1153681edc.102.1634057023019; Tue, 12 Oct 2021 09:43:43 -0700 (PDT) MIME-Version: 1.0 References: <20211012152601.GA20471@depesz.com> In-Reply-To: <20211012152601.GA20471@depesz.com> From: Agil Azimov Date: Tue, 12 Oct 2021 20:43:30 +0400 Message-ID: Subject: Re: Password settings requirements To: depesz@depesz.com Cc: pgsql-novice@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000665db205ce2a8cb8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000665db205ce2a8cb8 Content-Type: text/plain; charset="UTF-8" Yes I have checked it. The passwordcheck sets the predefined parameters which cannot be observed. I read somwhere that there is complexity check and password minimal length is set to 8 symbols. This doesn't work for me On Tue, 12 Oct 2021, 7:26 pm hubert depesz lubaczewski, wrote: > On Tue, Oct 12, 2021 at 07:00:17PM +0400, Agil Azimov wrote: > > Need to check the password settings in postgre such as Password minimal > > length, password complexity, password maximal age, password history and > > account lockout threshold. > > I need to set these parameters to make the comply with the best practices > > Can you please help with this issue? > > Did you check this: > https://www.postgresql.org/docs/current/passwordcheck.html ? > > Best regards, > > depesz > > --000000000000665db205ce2a8cb8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Yes I have checked it. The passwordcheck sets the pr= edefined parameters which cannot be observed. I read somwhere that there is= complexity check and password minimal length is set to 8 symbols. This doe= sn't work for me

On Tue, 12 Oct 2021, 7:26 pm hubert depesz lubaczewski, &= lt;depesz@depesz.com> wrote:
On Tue, Oct 12, 2021 at 07:00:17PM +0= 400, Agil Azimov wrote:
> Need to check the password settings in postgre such as Password minima= l
> length, password complexity, password maximal age, password history an= d
> account lockout threshold.
> I need to set these parameters to make the comply with the best practi= ces
> Can you please help with this issue?

Did you check this:
https://www.postgresql.org/doc= s/current/passwordcheck.html ?

Best regards,

depesz

--000000000000665db205ce2a8cb8--