X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 54B5CD1B430 for ; Wed, 26 Nov 2003 16:23:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 70108-04 for ; Wed, 26 Nov 2003 12:22:39 -0400 (AST) Received: from physics.gmu.edu (physics.gmu.edu [129.174.44.73]) by svr1.postgresql.org (Postfix) with ESMTP id 413DFD1B45C for ; Wed, 26 Nov 2003 12:22:33 -0400 (AST) Received: from physics.gmu.edu (localhost.localdomain [127.0.0.1]) by physics.gmu.edu (8.12.8/8.12.8) with ESMTP id hAQGKhFX019393 for ; Wed, 26 Nov 2003 11:20:43 -0500 From: mohan@physics.gmu.edu Received: (from apache@localhost) by physics.gmu.edu (8.12.8/8.12.8/Submit) id hAQGKhSj019391; Wed, 26 Nov 2003 11:20:43 -0500 X-Authentication-Warning: physics.gmu.edu: apache set sender to mohan@physics.gmu.edu using -f Received: from 138.88.163.115 (SquirrelMail authenticated user mohan) by physics.gmu.edu with HTTP; Wed, 26 Nov 2003 11:20:43 -0500 (EST) Message-ID: <62401.138.88.163.115.1069863643.squirrel@physics.gmu.edu> Date: Wed, 26 Nov 2003 11:20:43 -0500 (EST) Subject: Postgres: MS Access and Tomcat To: X-Priority: 3 Importance: Normal X-Mailer: SquirrelMail (version 1.2.11) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/295 X-Sequence-Number: 16110 Hi All I am using postgres database. Users of the DB include Web users thro tomcat and internal user thr'o MS Access. The problem is the users of Access sometimes do not close these connections and postgres fails saying too many connections for the web users. Is there a way i can resolve this by uncommenting the #Max_connections=32 in the postgresql.conf. What are the effects of uncommenting this part in postgresql.conf. Do i need to make any more changes when uncomment the Max_connections=32 in the postgresql.conf file Thank you very much --Mohan