Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 0A595632906
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  6 Apr 2010 16:19:42 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 02923-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  6 Apr 2010 19:19:27 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from lo.gmane.org (lo.gmane.org [80.91.229.12])
	by mail.postgresql.org (Postfix) with ESMTP id 3C6896328F5
	for <pgsql-admin@postgresql.org>; Tue,  6 Apr 2010 16:19:31 -0300 (ADT)
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-admin@m.gmane.org>) id 1NzEJ6-0006Qm-Lt
	for pgsql-admin@postgresql.org; Tue, 06 Apr 2010 21:19:28 +0200
Received: from 78.90.89.166 ([78.90.89.166])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-admin@postgresql.org>; Tue, 06 Apr 2010 21:19:28 +0200
Received: from milen by 78.90.89.166 with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-admin@postgresql.org>; Tue, 06 Apr 2010 21:19:28 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-admin@postgresql.org
From: "Milen A. Radev" <milen@radev.net>
Subject: Re: Configuration questions
Date: Tue, 06 Apr 2010 22:19:17 +0300
Lines: 13
Message-ID: <hpg1fp$jt5$1@dough.gmane.org>
References: <m2t7624f3d81004051311kdf823738sac1b05bb2ca8f97d@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: 78.90.89.166
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; bg;
	rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
In-Reply-To: <m2t7624f3d81004051311kdf823738sac1b05bb2ca8f97d@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.882 tagged_above=-10 required=5
	tests=BAYES_40=-0.185, RCVD_NUMERIC_HELO=2.067
X-Spam-Level: *
X-Archive-Number: 201004/56
X-Sequence-Number: 34150

На 05.4.2010 23:11, Kevin Crain написа:
[...]
> Also is there a way to limit the number of concurrent connections on a per
> account basis?

ALTER ROLE <role> CONNECTION LIMIT <number>;

(http://www.postgresql.org/docs/current/static/sql-alterrole.html)



-- 
Milen A. Radev