Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EF30A37C703 for ; Mon, 12 Nov 2007 11:39:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00568-04 for ; Mon, 12 Nov 2007 11:39:29 -0400 (AST) Received: from smtp6-g19.free.fr (smtp6-g19.free.fr [212.27.42.36]) by postgresql.org (Postfix) with ESMTP id 7618D37C6EA for ; Mon, 12 Nov 2007 11:39:28 -0400 (AST) Received: from smtp6-g19.free.fr (localhost.localdomain [127.0.0.1]) by smtp6-g19.free.fr (Postfix) with ESMTP id CB41B5FEB0 for ; Mon, 12 Nov 2007 16:39:25 +0100 (CET) Received: from imp9-g19.free.fr (imp9-g19.free.fr [212.27.42.68]) by smtp6-g19.free.fr (Postfix) with ESMTP id A6A6D5FECF for ; Mon, 12 Nov 2007 16:39:25 +0100 (CET) Received: by imp9-g19.free.fr (Postfix, from userid 33) id 828F72E6CA; Mon, 12 Nov 2007 16:39:25 +0100 (CET) Received: from proxy.ovh.net (proxy.ovh.net [213.186.50.98]) by imp.free.fr (IMP) with HTTP for ; Mon, 12 Nov 2007 16:39:25 +0100 Message-ID: <1194881965.473873ad3aa77@imp.free.fr> Date: Mon, 12 Nov 2007 16:39:25 +0100 From: beluc.mailing@free.fr To: pgsql-admin@postgresql.org Subject: max connections per user MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.5 X-Originating-IP: 213.186.50.98 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200711/94 X-Sequence-Number: 27337 hi, i would like to know if it is possible to limit the number of connections per user. if postgresql.conf, i just see a "max connections" parameter but it's a global parameter. i think i can do this using iptables, but i would be more convenient to do this in pg.