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 24162D1B48C for ; Sun, 13 Jun 2004 19:51:46 -0300 (ADT) 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 72547-01 for ; Sun, 13 Jun 2004 22:51:44 +0000 (GMT) Received: from www.liukuma.net (www.liukuma.net [62.220.235.15]) by svr1.postgresql.org (Postfix) with ESMTP id 65026D1B34E for ; Sun, 13 Jun 2004 19:51:40 -0300 (ADT) Received: by www.liukuma.net (Postfix, from userid 1000) id 8EC5B5657; Mon, 14 Jun 2004 01:51:42 +0300 (EEST) Received: from localhost (localhost [127.0.0.1]) by www.liukuma.net (Postfix) with ESMTP id 8405555B0 for ; Mon, 14 Jun 2004 01:51:42 +0300 (EEST) Date: Mon, 14 Jun 2004 01:51:42 +0300 (EEST) From: Reko Turja To: pgsql-admin@postgresql.org Subject: Re: FreeBSD SHMMAX In-Reply-To: Message-ID: <20040614015053.O21833@www.liukuma.net> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/162 X-Sequence-Number: 13822 > I am trying to get Postgres running on FreeBSD and am running into > problems > with shared mem. Here is the postgres error messge: On my box the values defined for the kernel are as follow: options SHMMAXPGS=65536 #For postgreSQL options SEMMNI=40 options SEMMNS=240 options SEMUME=40 options SEMMNU=120 If my memory serves me right these values were suggested for PgSQL in FBSD or Postgres documentation. and the corresponding sysctls: kern.ipc.shmmax: 268435456 kern.ipc.shmmin: 1 kern.ipc.shmmni: 192 kern.ipc.shmseg: 128 kern.ipc.shmall: 65536 your kern.ipc.shmall seems a bit low comparing to my setup, maybe the culprit is there. You can tune that sysctl at runtime, try if giving it higher value helps. -Reko