Re: limiting number of connections from specific host or by user

On Wed, May 10, 2006 at 12:06:46PM -0700, Kenji Morishige wrote:
> Is there any way from PostgreSQL user authentication or other
> methods to cap connection count by user or by host?

What version are you running?  8.1 has per-user and per-database
connection limits; search for CONNECTION LIMIT in the following
documentation:

http://www.postgresql.org/docs/8.1/interactive/sql-alteruser.html
http://www.postgresql.org/docs/8.1/interactive/sql-alterrole.html
http://www.postgresql.org/docs/8.1/interactive/sql-alterdatabase.html

--
Michael Fuhr