From owner-freebsd-questions@FreeBSD.ORG  Mon Mar 20 20:33:14 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id C69EE16A400
	for <freebsd-questions@freebsd.org>;
	Mon, 20 Mar 2006 20:33:14 +0000 (UTC)
	(envelope-from mmiranda@123.com.sv)
Received: from asgard1.americatelsal.com (asgard.americatelsal.com
	[200.13.161.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id ECF4743D77
	for <freebsd-questions@freebsd.org>;
	Mon, 20 Mar 2006 20:33:09 +0000 (GMT)
	(envelope-from mmiranda@123.com.sv)
Received: (qmail 53369 invoked from network); 20 Mar 2006 20:55:49 -0000
Received: from unknown (HELO ?192.168.10.124?) (200.13.161.68)
	by asgard1.americatelsal.com with SMTP; 20 Mar 2006 20:55:49 -0000
Message-ID: <441F125F.8030101@123.com.sv>
Date: Mon, 20 Mar 2006 14:36:47 -0600
From: Miguel <mmiranda@123.com.sv>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: freebsd-questions@freebsd.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: setting shmmax for postgres
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 20 Mar 2006 20:33:14 -0000

Hi, how can i set the shmmax parameter in freebsd 6.1?

i tried this in /etc/sysctl.conf

kern.ipc.shmmax=1147483647


shiva2# sysctl -a kern.ipc.shmmax
kern.ipc.shmmax: 2147483647

but postgres always fails with this error

The PostgreSQL documentation contains more information about shared 
memory configuration.
FATAL:  could not create shared memory segment: Cannot allocate memory
DETAIL:  Failed system call was shmget(key=5432001, size=1149067264, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared 
memory segment exceeded available memory or swap space. To reduce the 
request size (currently 1149067264 bytes), reduce PostgreSQL's 
shared_buffers parameter (currently 137626) and/or its max_connections 
parameter (currently 200).


do i have to recompile the kernel ?

thanks