Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 246FB633B85 for ; Thu, 19 Mar 2009 12:16:05 -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 53885-09 for ; Thu, 19 Mar 2009 12:16:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fmf.vtu.lt (fmf.vgtu.lt [193.219.145.206]) by mail.postgresql.org (Postfix) with ESMTP id 3F7E763230A for ; Thu, 19 Mar 2009 12:15:57 -0300 (ADT) Received: from fmf.vgtu.lt (localhost [127.0.0.1]) by fmf.vtu.lt (Postfix) with ESMTP id 5A7B51001F for ; Thu, 19 Mar 2009 17:11:21 +0200 (EET) Received: from 217.117.29.29 (SquirrelMail authenticated user nso) by fmf.vgtu.lt with HTTP; Thu, 19 Mar 2009 17:11:21 +0200 (EET) Message-ID: <7844.217.117.29.29.1237475481.squirrel@fmf.vgtu.lt> Date: Thu, 19 Mar 2009 17:11:21 +0200 (EET) Subject: Connection limit per user From: "Lukas" To: pgsql-admin@postgresql.org Reply-To: Lukas@fmf.vtu.lt User-Agent: SquirrelMail/1.4.8 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-VGTU-MailScanner-OpenProtect-Information: Please contact the ISP for more information X-VGTU-MailScanner-OpenProtect: Found to be clean X-VGTU-MailScanner-OpenProtect-MCPCheck: X-VGTU-MailScanner-OpenProtect-From: lukas@fmf.vtu.lt 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/198 X-Sequence-Number: 31698 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 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.