Postgres Pro
Downloads
Home   >   mailing lists

Thread: Client Connections

Client Connections

From
Curtis Scheer
Date:

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

 

Thanks,

 

Curtis

Re: Client Connections

From
Michael Fuhr
Date:
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

Re: Client Connections

From
"Joshua D. Drake"
Date:
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/