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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lJgy9-0005hz-Ai
	for pgsql-admin@arkaria.postgresql.org; Tue, 09 Mar 2021 18:20:33 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lJgy8-0000pw-8r
	for pgsql-admin@arkaria.postgresql.org; Tue, 09 Mar 2021 18:20:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1lJgy8-0000pn-1C
	for pgsql-admin@lists.postgresql.org; Tue, 09 Mar 2021 18:20:32 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1lJgy5-0004t1-VO
	for pgsql-admin@lists.postgresql.org; Tue, 09 Mar 2021 18:20:31 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 129IKRGU2037258;
	Tue, 9 Mar 2021 13:20:27 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: postbox giridhar <giridharpostbox@gmail.com>
cc: pgsql-admin@lists.postgresql.org
Subject: Re: Lock after several failed login attempts
In-reply-to: 
 <CALjFJF2TdnNZ3ZbFBV8Dn4BWdiJSn_zCoWw_82wUjbnHR6VSZg@mail.gmail.com>
References: 
 <CALjFJF2TdnNZ3ZbFBV8Dn4BWdiJSn_zCoWw_82wUjbnHR6VSZg@mail.gmail.com>
Comments: In-reply-to postbox giridhar <giridharpostbox@gmail.com>
	message dated "Tue, 09 Mar 2021 23:42:06 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2037256.1615314027.1@sss.pgh.pa.us>
Date: Tue, 09 Mar 2021 13:20:27 -0500
Message-ID: <2037257.1615314027@sss.pgh.pa.us>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/2037257.1615314027%40sss.pgh.pa.us>
Precedence: bulk

postbox giridhar <giridharpostbox@gmail.com> writes:
> Is it possible to lock a database user after several failed login attempts.

No such thing is built into PG.  You can use external authentication
solutions, such as PAM, for this and related requirements.

			regards, tom lane