Thread: Limit connections per username

Limit connections per username

From

Nik

Date:

13 July 2007, 01:16:01

PostgreSQL 8.2 on Windows 2003 Server.

Is it possible to limit number of connections per username?

Re: Limit connections per username

From

Stefan Kaltenbrunner

Date:

13 July 2007, 11:20:17

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