Re: Client Connections - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Client Connections
Date
Msg-id 20060914161403.GA59971@winnie.fuhr.org
Whole thread Raw
In response to Client Connections  (Curtis Scheer <Curtis@DAYCOS.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Bernhard Weisshuhn
Date:
Subject: Re: PostgreSQL slammed by PHP creator
Next
From: Berend Tober
Date:
Subject: Re: PostgreSQL slammed by PHP creator