X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 13607D1D2C3
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Tue, 16 Mar 2004 14:31:06 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 86530-03
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Tue, 16 Mar 2004 10:31:07 -0400 (AST)
Received: from web41013.mail.yahoo.com (web41013.mail.yahoo.com
 [66.218.93.12])
	by svr1.postgresql.org (Postfix) with SMTP id 812F2D1D282
	for <pgsql-bugs@postgresql.org>; Tue, 16 Mar 2004 10:31:03 -0400 (AST)
Message-ID: <20040316143107.78536.qmail@web41013.mail.yahoo.com>
Received: from [63.142.169.9] by web41013.mail.yahoo.com via HTTP;
	Tue, 16 Mar 2004 06:31:07 PST
Date: Tue, 16 Mar 2004 06:31:07 -0800 (PST)
From: Theodore Petrosky <tedpet5@yahoo.com>
Subject: Re: [SQL] could not create shared memory segment: Invalid argument
To: pgsql -bugs <pgsql-bugs@postgresql.org>
In-Reply-To: <Pine.LNX.4.44.0403161442500.1464-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/118
X-Sequence-Number: 8078

You must edit the file /etc/rc ( sudo pico /ect/rc  )

find the system tuning section and change as follows:

sysctl -w kern.sysv.shmmax=167772160 
sysctl -w kern.sysv.shmmin=1 
sysctl -w kern.sysv.shmmni=32 
sysctl -w kern.sysv.shmseg=8 
sysctl -w kern.sysv.shmall=65536 


warning... this change will not survive a system
update that updates the /etc/rc file.

Ted
--- Achilleus Mantzios <achill@matrix.gatewaynet.com>
wrote:
> O kyrios beyaNet Consultancy egrapse stis Mar 16,
> 2004 :
> 
> > Hi,
> > I have just installed the latest version of OS X
> panther (10.3.3) and 
> > am now getting the following error message:
> 
> For start do:
> 
> sysctl -a | grep -i shm
> or equivalent to find out your current kernel
> settings.
> 
> in FreeBSD the way to change shmmax is
> 
> # sysctl sysctl kern.ipc.shmmax=<some size>
> 
> I dont know about OSX tho..
> 
> > 
> > postgres$ /usr/local/pgsql/bin/postmaster -i -D
> /usr/local/pgsql/data
> > FATAL:  could not create shared memory segment:
> Invalid argument
> > DETAIL:  Failed system call was
> shmget(key=5432001, size=10444800, 
> > 03600).
> > HINT:  This error usually means that PostgreSQL's
> request for a shared 
> > memory segment exceeded your kernel's SHMMAX
> parameter.  You can either 
> > reduce the request size or reconfigure the kernel
> with larger SHMMAX.  
> > To reduce the request size (currently 10444800
> bytes), reduce 
> > PostgreSQL's shared_buffers parameter (currently
> 1000) and/or its 
> > max_connections parameter (currently 100).
> >          If the request size is already small,
> it's possible that it is 
> > less than your kernel's SHMMIN parameter, in which
> case raising the 
> > request size or reconfiguring SHMMIN is called
> for.
> >          The PostgreSQL documentation contains
> more information about 
> > shared memory configuration.
> > 
> > Any ideas on how i can resolve this issue?
> > 
> > many thanks in advance
> > 
> > 
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> > 
> 
> -- 
> -Achilleus
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com