Skip site navigation (1) Skip section navigation (2)

Re: Locking out a user after several failed login attempts

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: "mark" <dvlhntr(at)gmail(dot)com>
Cc: "'Mike Thomsen'" <mikerthomsen(at)gmail(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Locking out a user after several failed login attempts
Date: 2011-06-30 15:44:05
Message-ID: 20110630174405.3f2b2224@anubis.defcon1 (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, 30 Jun 2011 07:10:43 -0600, "mark" <dvlhntr(at)gmail(dot)com> wrote:

> 
> That might be a ok on a small application with a limited number of users. A
> few thousand login attempts per min and you are probably going to wish the
> counter lived outside of your RDBMS. 

As pg is able to sustain large loads, I don't see why.  But you can
externalize if you want, using dblink.

-- 
The weed of crime bears bitter fruit... but the leaves are good to smoke!
		-- The Shadow

In response to

pgsql-novice by date

Next:From: Vincent MichelDate: 2011-06-30 16:33:09
Subject: Fast identifiers table creation
Previous:From: Mäggi HieberDate: 2011-06-30 15:15:23
Subject: change data type 'money' to '€'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group