Re: [GENERAL] Limit connections per username

[Stefan Kaltenbrunner]

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

---(end of broadcast)---
TIP 6: explain analyze is your friend

[GENERAL] Limit connections per username

[Nik]

PostgreSQL 8.2 on Windows 2003 Server.

Is it possible to limit number of connections per username?


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly