From: Guillaume Lelarge <guillaume@lelarge.info>
To: Francisco Reyes <lists@stringsutils.com>
Cc: Kevin Crain <kevin.crain1@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Configuration questions
Date: Tue, 06 Apr 2010 22:23:37 +0200
Message-ID: <4BBB9849.7080207@lelarge.info> (raw)
In-Reply-To: <cone.1270579505.757273.18171.1000@shelca>
References: <m2t7624f3d81004051311kdf823738sac1b05bb2ca8f97d@mail.gmail.com>
<cone.1270579505.757273.18171.1000@shelca>
Le 06/04/2010 20:45, Francisco Reyes a écrit :
> Kevin Crain writes:
>
>> How do I configure postgres to lock a user's account after X failed
>> login attempts, where X is an arbitrary number.
>
> Don't think there is a way to do that.
> Perhaps using an authentication mechanism that supports that and then
> using it to connect to Postgres..
> This page may be of interest:
> http://www.postgresql.org/docs/current/static/auth-methods.html
>
Yeah, an external authentication tool can probably do that. The internal
ones (password, md5, and crypt) won't.
>> Also is there a way to limit the number of concurrent connections on a
>> per account basis?
>
> Don't think there is an option for that either.
>
Sure, there is one:
ALTER ROLE your-user WITH CONNECTION LIMIT x;
See http://www.postgresql.org/docs/8.4/interactive/sql-alterrole.html
for more details.
--
Guillaume.
http://www.postgresqlfr.orghttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, lists@stringsutils.com, kevin.crain1@gmail.com
Subject: Re: Configuration questions
In-Reply-To: <4BBB9849.7080207@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox