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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Kenji Morishige <kenjim(at)juniper(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: limiting number of connections from specific host or by user
Date: 2006-05-10 19:57:24
Message-ID: 20060510195724.GA27845@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2006-05-10 20:14:23 Re: backups
Previous Message Sisyphus 2006-05-10 19:45:52 posgresql AltLinux