X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 7F2AC30DF42 for ; Thu, 19 Jun 2003 18:39:07 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 06263-01 for ; Thu, 19 Jun 2003 15:38:56 -0300 (ADT) Received: from curry.tmsl.demon.co.uk (tmsl-adsl.demon.co.uk [80.177.114.181]) by svr1.postgresql.org (Postfix) with ESMTP id 631F430DF1A for ; Thu, 19 Jun 2003 15:38:55 -0300 (ADT) Received: from bacon.tmsl.demon.co.uk (bacon.tmsl.demon.co.uk [192.168.7.102]) by curry.tmsl.demon.co.uk (8.11.6/8.11.6) with ESMTP id h5JIcrl21878 for ; Thu, 19 Jun 2003 19:38:53 +0100 Date: Thu, 19 Jun 2003 19:38:46 +0100 From: Paul Thomas To: "pgsql-sql @ postgresql . org" Subject: Re: [JDBC] maxconnection Message-ID: <20030619193846.A21606@bacon> References: <00dc01c334b2$04876130$d400a8ca@zhuj2k> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=gb2312 In-Reply-To: <00dc01c334b2$04876130$d400a8ca@zhuj2k>; from zhuj@dragontec.com.cn on Tue, Jun 17, 2003 at 10:22:47 +0100 X-Mailer: Balsa 1.2.3 Lines: 21 X-Archive-Number: 200306/230 X-Sequence-Number: 13988 On 17/06/2003 10:22 zhuj wrote: > hi,all: > I want to constraint the maximum number of concurrent connections to > 25 > in postgres > jdbc driver. There are no methods for this > change. How would i do? The simplest way is to use a connection pool. HTH -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+