X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E458D3A48F7 for ; Wed, 1 Dec 2004 18:44:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21237-06 for ; Wed, 1 Dec 2004 18:44:15 +0000 (GMT) Received: from digi1.shellsystem.de (shellsystem.de [62.216.184.150]) by svr1.postgresql.org (Postfix) with ESMTP id 5F0183A3B0B for ; Wed, 1 Dec 2004 18:44:15 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by digi1.shellsystem.de (digi1.shellsystem.de) with ESMTP id 65EBD6EC17B; Wed, 1 Dec 2004 19:44:13 +0100 (CET) Received: from digi1.shellsystem.de ([127.0.0.1]) by localhost (digi1 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20988-01; Wed, 1 Dec 2004 19:44:13 +0100 (CET) Received: by digi1.shellsystem.de (digi1.shellsystem.de, from userid 33) id 24C296EC067; Wed, 1 Dec 2004 19:44:13 +0100 (CET) To: Tom Lane Subject: Re: "too many clients" and no cure From: postgresql@thomasbache.de X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal X-MimeOLE: Produced by Confixx WebMail X-Mailer: Confixx WebMail (like SquirrelMail) Cc: pgsql-admin@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 8bit Message-Id: <20041201184413.24C296EC067@digi1.shellsystem.de> Date: Wed, 1 Dec 2004 19:44:13 +0100 (CET) X-Virus-Scanned: by amavisd-new-20030616-p3 (Debian) at shellsystem.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200412/25 X-Sequence-Number: 15611 > In that case, maybe you edited the wrong copy of postgresql.conf? > Try checking "SHOW max_connections" to verify what the postmaster > thinks the value is. Hmm, it said it still had 100. Even though the postgresql.conf stayed unchanged, after yet another restart it works. Funny. > I don't think kernel limits would lead to "too many clients" --- you'd > be getting different sorts of failures if the problem were in that area. Thanks a lot ! Tom