Received: from rakete.joerdens.de ([62.104.116.200]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2CHkUx39662 for ; Mon, 12 Mar 2001 12:46:30 -0500 (EST) (envelope-from frank@rakete.joerdens.de) Received: (from frank@localhost) by rakete.joerdens.de (8.9.3/8.9.3) id SAA03169; Mon, 12 Mar 2001 18:46:26 +0100 Date: Mon, 12 Mar 2001 18:46:26 +0100 From: Frank Joerdens To: Najm Hashmi Cc: pgsql Subject: Re: Max Conncection limit? Message-ID: <20010312184626.A3110@rakete.joerdens.de> References: <3AAE4BC6.97FDD3AD@mondo-live.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.1.2i In-Reply-To: <3AAE4BC6.97FDD3AD@mondo-live.com>; from najm@mondo-live.com on Tue, Mar 13, 2001 at 11:33:10AM -0500 X-Subliminal-Message: Use Linux! Use Linux! X-Archive-Number: 200103/223 X-Sequence-Number: 1877 On Tue, Mar 13, 2001 at 11:33:10AM -0500, Najm Hashmi wrote: > We start a server and initiate 30 connections(with the libpq C interface) > which are stored in a stack to use and and to be reused. > > After awhile I try to start another server that will also try to initiate 30 > connections, for each connection I then get a PQErrorMessage like that : > "Sorry, too many connections" > > if I do a ps -ax at that time I get a lot of /usr/bin/postgres 192.168.0.1 > user name passwd idle > > what I usually do is restart postgres but I wish I didnt have to do that... > That is not an elegant solutuion any ways. > What can I do? Thanks in advance. Regards Have a look at the runtime-config.html in the admin section of the manual: MAX_CONNECTIONS (integer) Determines how many concurrent connections the database server will allow. The default is 32. There is also a compiled-in hard upper limit on this value, which is typically 1024 (both numbers can be altered when compiling the server). This parameter can only be set at server start. Regards, Frank