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 DC48E3A4884 for ; Wed, 1 Dec 2004 17:20:16 +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 90829-05 for ; Wed, 1 Dec 2004 17:20:10 +0000 (GMT) Received: from digi1.shellsystem.de (shellsystem.de [62.216.184.150]) by svr1.postgresql.org (Postfix) with ESMTP id 6A44F3A55B3 for ; Wed, 1 Dec 2004 17:20:09 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by digi1.shellsystem.de (digi1.shellsystem.de) with ESMTP id B9E806EC193; Wed, 1 Dec 2004 18:20:05 +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 04324-01; Wed, 1 Dec 2004 18:20:05 +0100 (CET) Received: by digi1.shellsystem.de (digi1.shellsystem.de, from userid 33) id 738A26EC191; Wed, 1 Dec 2004 18:20:05 +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: <20041201172005.738A26EC191@digi1.shellsystem.de> Date: Wed, 1 Dec 2004 18:20:05 +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/20 X-Sequence-Number: 15606 > It sounds like you forgot to restart the postmaster after changing > postgresql.conf. This is one of the parameters that is frozen at server > start ... No, I did restart the postmaster. Actually more than once. I do not have to restart the server after changing kernel parameters with sysctl, do I? Do you have any other ideas? I'm having trouble since a week or so ...