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 3CBEB3A4961 for ; Wed, 1 Dec 2004 16:15:53 +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 70605-02 for ; Wed, 1 Dec 2004 16:15:44 +0000 (GMT) Received: from digi1.shellsystem.de (shellsystem.de [62.216.184.150]) by svr1.postgresql.org (Postfix) with ESMTP id 0571B3A461A for ; Wed, 1 Dec 2004 16:15:42 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by digi1.shellsystem.de (digi1.shellsystem.de) with ESMTP id 0E9476EC183 for ; Wed, 1 Dec 2004 17:15:39 +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 26422-07 for ; Wed, 1 Dec 2004 17:15:38 +0100 (CET) Received: by digi1.shellsystem.de (digi1.shellsystem.de, from userid 33) id C5EBB6EC064; Wed, 1 Dec 2004 17:15:38 +0100 (CET) To: pgsql-admin@postgresql.org Subject: "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: Content-Type: text/plain Content-Transfer-Encoding: 8bit Message-Id: <20041201161538.C5EBB6EC064@digi1.shellsystem.de> Date: Wed, 1 Dec 2004 17:15:38 +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/18 X-Sequence-Number: 15604 Hi, I experience some trouble with my PG server. I get the error message "too many clients". Ok, so I checked the manual and adjusted the max_connections and shared_buffers, but still the server denies access, if there are about 100 connections. I just recently increased the shared buffers from 10000 to 50000 and the system shared memory fom 128m to about 800m. Still the error occurs at 100 active connections. Here's some system info: OS is SuSE Linux 9.1 (kernel 2.6.7-040722) I have 1GB of RAM. PG is 7.4.2 Parameters in postgresql.conf: max_connections = 500 shared_buffers = 50000 sort_mem = 2048 sysctl -a | grep shm kernel.shmmni = 134217728 kernel.shmall = 805306368 kernel.shmmax = 805306368 ipcs -ls ------ Semaphore Limits -------- max number of arrays = 128 max semaphores per array = 250 max semaphores system wide = 32000 max ops per semop call = 100 semaphore max value = 32767 Thanks, Tom