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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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