From owner-freebsd-questions@FreeBSD.ORG Thu Dec 6 03:52:16 2007 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3A97516A41A for ; Thu, 6 Dec 2007 03:52:16 +0000 (UTC) (envelope-from kdk@daleco.biz) Received: from ezekiel.daleco.biz (southernuniform.com [66.76.92.18]) by mx1.freebsd.org (Postfix) with ESMTP id E339F13C46B for ; Thu, 6 Dec 2007 03:52:15 +0000 (UTC) (envelope-from kdk@daleco.biz) Received: from localhost (localhost [127.0.0.1]) by ezekiel.daleco.biz (8.13.8/8.13.8) with ESMTP id lB63q9WM089848; Wed, 5 Dec 2007 21:52:09 -0600 (CST) (envelope-from kdk@daleco.biz) X-Virus-Scanned: amavisd-new at daleco.biz Received: from ezekiel.daleco.biz ([127.0.0.1]) by localhost (ezekiel.daleco.biz [127.0.0.1]) (amavisd-new, port 10024) with LMTP id qAep4l4QmPVs; Wed, 5 Dec 2007 21:52:05 -0600 (CST) Received: from archangel.daleco.biz (dsl.daleco.biz [209.125.108.70]) by ezekiel.daleco.biz (8.13.8/8.13.8) with ESMTP id lB63pxOk089843; Wed, 5 Dec 2007 21:52:00 -0600 (CST) (envelope-from kdk@daleco.biz) Message-ID: <475771D9.1090004@daleco.biz> Date: Wed, 05 Dec 2007 21:51:53 -0600 From: Kevin Kinsey User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.1.2) Gecko/20070418 SeaMonkey/1.1.1 MIME-Version: 1.0 To: Gergely CZUCZY References: <20071205114619.GA32423@harmless.hu> <200712051701.lB5H12Ih058055@casselton.net> <20071205225932.GB15474@harmless.hu> In-Reply-To: <20071205225932.GB15474@harmless.hu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: more then 2G shm on RELENG_7 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 06 Dec 2007 03:52:16 -0000 Gergely CZUCZY wrote: > Amd64, of course. > > Dec 5 11:43:11 sqltest postgres[1091]: [1-1] FATAL: could not create shared memory segment: Cannot allocate memory > Dec 5 11:43:11 sqltest postgres[1091]: [1-2] DETAIL: Failed system call was shmget(key=5432001, size=2151309312, 03600). > > That's all I got from the logs. > I'm sure you've seen this in the PGSQL docs: ---------------------------- A message like FATAL: could not create shared memory segment: Invalid argument DETAIL: Failed system call was shmget(key=5440001, size=4011376640, 03600). probably means your kernel's limit on the size of shared memory is smaller than the work area PostgreSQL is trying to create (4011376640 bytes in this example). Or it could mean that you do not have System-V-style shared memory support configured into your kernel at all. As a temporary workaround, you can try starting the server with a smaller-than-normal number of buffers (shared_buffers). You will eventually want to reconfigure your kernel to increase the allowed shared memory size. You may also see this message when trying to start multiple servers on the same machine, if their total space requested exceeds the kernel limit. ---------------------------- You might look in the FreeBSD GNATS database at bug 77353, and see if the advice there assists you in correction of the problem. HTH, Kevin Kinsey -- If people see that you mean them no harm, they'll never hurt you, nine times out of ten!