Re: Limit connections per username

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Nik <XLPizza(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Limit connections per username
Date: 2007-07-13 11:20:05
Message-ID: 46975FE5.7050600@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nik wrote:
> PostgreSQL 8.2 on Windows 2003 Server.
>
> Is it possible to limit number of connections per username?

yes - look for CONNECTION LIMIT on:

http://www.postgresql.org/docs/8.2/static/sql-createrole.html
and
http://www.postgresql.org/docs/8.2/static/sql-alterrole.html

Stefan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2007-07-13 11:25:07 Re: Limit number connections by IP
Previous Message Robert Treat 2007-07-13 10:53:20 Re: Force SSL / username combination