Failed Login Attempts parameter

Lists: pgsql-general
From: Frank Cavaliero <fcavalie(at)us(dot)ibm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Failed Login Attempts parameter
Date: 2012-11-14 21:04:34
Message-ID: OFAD24079F.8760E63F-ON85257AB6.00736888-85257AB6.0073C6C0@us.ibm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hi,

I've been searching the web and reviewing documentation, but I cannot find
any reference to whether or not a parameter, for example,
failed_login_attempts, exists in PostgreSQL that determines the number of
attempts a user can make before being locked. In addition, if such a
parameter or similar setup exists, is there also some database object that
provides a current count of the failed login attempts?

Thanks,
Frank

Frank Cavaliero
Database Administrator
IBM Infosphere Guardium
IBM Software Group, Information Management
978-899-3635 - Direct
For Technical Services Support Please Call 978-899-9195.

This communication is intended only for the use of the individual or
entity named as the addressee. It may contain information which is
privileged and/or confidential under applicable law. If you are not the
intended recipient or such recipient's employee or agent, you are hereby
notified that any dissemination, copy or disclosure of this communication
is strictly prohibited. If you have received this communication in error,
please immediately notify us at 978-899-9195 or notify the sender by reply
e-mail and expunge this communication without making any copies. Thank
you for your cooperation.


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Frank Cavaliero <fcavalie(at)us(dot)ibm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Failed Login Attempts parameter
Date: 2012-11-14 21:21:14
Message-ID: 26205.1352928074@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Frank Cavaliero <fcavalie(at)us(dot)ibm(dot)com> writes:
> I've been searching the web and reviewing documentation, but I cannot find
> any reference to whether or not a parameter, for example,
> failed_login_attempts, exists in PostgreSQL that determines the number of
> attempts a user can make before being locked.

There is not in the core database code. But if you use PAM
authentication, there are plenty of pluggable modules that do that and
ninety-nine other specialized things you might wish to have in the
authentication code path.

regards, tom lane