Received: from lin.local.lan ([216.221.221.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2CGQbx29205 for ; Mon, 12 Mar 2001 11:26:37 -0500 (EST) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@najm.local2.lan [192.168.2.20]) by lin.local.lan (8.9.3/8.8.7) with ESMTP id QAA09510 for ; Mon, 12 Mar 2001 16:05:11 GMT Message-ID: <3AAE4BC6.97FDD3AD@mondo-live.com> Date: Tue, 13 Mar 2001 11:33:10 -0500 From: Najm Hashmi X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql Subject: Max Conncection limit? Content-Type: multipart/mixed; boundary="------------1F7B10DE594A14156BD9563F" X-Archive-Number: 200103/222 X-Sequence-Number: 1876 This is a multi-part message in MIME format. --------------1F7B10DE594A14156BD9563F Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 --------------1F7B10DE594A14156BD9563F Content-Type: text/x-vcard; charset=us-ascii; name="najm.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Najm Hashmi Content-Disposition: attachment; filename="najm.vcf" begin:vcard n:Hashmi;Najm x-mozilla-html:FALSE org:Mondo-Live.com;www.flipr.com adr:;;;;;; version:2.1 email;internet:najm@mondo-live.com x-mozilla-cpt:;6144 fn:Najm Hashmi end:vcard --------------1F7B10DE594A14156BD9563F--