Обсуждение: 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/