Обсуждение: Limit connections per username

PostgreSQL 8.2 on Windows 2003 Server.

Is it possible to limit number of connections per username?

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