Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 951946324DC
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 19 Mar 2009 12:42:28 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 60467-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 19 Mar 2009 12:42:27 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ti-out-0910.google.com (ti-out-0910.google.com
 [209.85.142.187])
	by mail.postgresql.org (Postfix) with ESMTP id D62A8632231
	for <pgsql-admin@postgresql.org>; Thu, 19 Mar 2009 12:42:22 -0300 (ADT)
Received: by ti-out-0910.google.com with SMTP id w4so420898tib.5
	for <pgsql-admin@postgresql.org>; Thu, 19 Mar 2009 08:42:18 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from
	:user-agent:mime-version:to:cc:subject:references:in-reply-to
	:content-type:content-transfer-encoding;
	bh=9ZJ8g8eRkbADrpBgiCMKxzcl2OFu3YWXej3OfIfm768=;
	b=jPskDgV+5p95tVQrrSb4O1ld6Q/4Rc4sd8UW/F1n4ZvHXeRY4CxOPl0afdjICuUz4c
	+0tf0bqppSZkAuVr7ih62fkznuIGzxjrpXMZckByct3E90Kh+UKrMGC07J89eqdKtcXg
	9ZNOYZ64Ln+rDmSlUKPH6hXfubkVEFzoty7ZE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=T/Kx6T3RqiVawejLutthEEtIQNihzajLySpcWz67urYakZiDLXEuSqNsccdZLY3yHN
	BuBKRTPaFICdZjNLwpkplA4UrIKT7jF3ZRAHUgoBJjGnh7SRXCPR7lYZo+n9DyZW2c5/
	lCrANGVy6nOXVcPLE3Gl+TzGywvofmKzH83YI=
Received: by 10.110.53.14 with SMTP id b14mr4123786tia.48.1237477337070;
	Thu, 19 Mar 2009 08:42:17 -0700 (PDT)
Received: from ?192.168.23.132? ([121.241.184.130])
	by mx.google.com with ESMTPS id y3sm1172587tia.3.2009.03.19.08.42.13
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Thu, 19 Mar 2009 08:42:15 -0700 (PDT)
Message-ID: <49C267D1.5040909@gmail.com>
Date: Thu, 19 Mar 2009 21:12:09 +0530
From: Vibhor Kumar <vibhor.aim@gmail.com>
User-Agent: Thunderbird 2.0.0.19 (X11/20090105)
MIME-Version: 1.0
To: Lukas@fmf.vtu.lt
CC: pgsql-admin@postgresql.org
Subject: Re: Connection limit per user
References: <7844.217.117.29.29.1237475481.squirrel@fmf.vgtu.lt>
In-Reply-To: <7844.217.117.29.29.1237475481.squirrel@fmf.vgtu.lt>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/199
X-Sequence-Number: 31699

Hello Lukas,

You would be able to achieve it using the alter user command as given below:
alter user <user name> with CONNECTION LIMIT 2;


Lukas wrote:
> Hello,
>
>  is here any way to set connection limit to database per database user?
>  For ex. if I have postgresql database user XXX I want limit it to 2
> connections per database (or per all databases)..
>
>
> --
> Lukas
> UAB nSoft
> http://www.nsoft.lt
> Lukas at nsoft.lt
> +370 655 10 655
>
>
>
>