X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A4F49D1BB23 for ; Thu, 21 Aug 2003 08:54:03 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 80772-02 for ; Thu, 21 Aug 2003 08:53:56 -0300 (ADT) Received: from localhost.localdomain (unknown [202.181.234.12]) by svr1.postgresql.org (Postfix) with ESMTP id B1FF3D1BB0B for ; Thu, 21 Aug 2003 08:53:51 -0300 (ADT) Received: from mktam ([202.181.183.119]) by localhost.localdomain (8.11.6/8.9.3) with SMTP id h7LBkjv03380 for ; Thu, 21 Aug 2003 19:46:46 +0800 Message-ID: <00d001c367db$54c98ea0$1400a8c0@DIGITALONE> From: "Tam MK" To: Subject: More connections in Solaris9 Date: Thu, 21 Aug 2003 19:56:57 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200308/298 X-Sequence-Number: 3114 I try to increase my no. of connections of the Postmaster in my client's Solaris9 box but fails: When startup using bin/postmaster -N 300 -B 2000 -D /export/data, I got the message: IpcSemaphoreCreate: semget(key=5432004, num=17, 03600) failed: No space left on device This error does *not* mean that you have run out of disk space. It occurs either because system limit for the maximum number of semaphore sets (SEMMNI), or the system wide maximum number of semaphores (SEMMNS), would be exceeded. You need to raise the respective kernel parameter. Look into the PostgreSQL documentation for details. So what should I set for SEMMNI and SEMMNS? Any suggestion? The /etc/system file (partial) is set with the following: set shmsys:shminfo_shmmax=0x7fffffff set rlim_fd_max=8192 set rlim_fd_cur=4096 Regards, Tam MK