Client Connections

On Thu, Sep 14, 2006 at 10:59:09AM -0500, Curtis Scheer wrote:

Is there a setting to limit the number of database connections per IP
address or client?

8.1 has per-database and per-user connection limits; see the
CONNECTION LIMIT option of {CREATE,ALTER} {DATABASE,ROLE}.

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

--
Michael Fuhr

Curtis Scheer wrote:

Is there a setting to limit the number of database connections per IP
address or client?

No but you can limit per database as a whole.

Joshua D. Drake

Thanks,

Curtis

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/