X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id E92D0D1E917
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 16 Mar 2004 12:44:02 +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 41909-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 16 Mar 2004 08:44:04 -0400 (AST)
Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50])
	by svr1.postgresql.org (Postfix) with ESMTP id 41AB4D1E90B
	for <pgsql-sql@postgresql.org>; Tue, 16 Mar 2004 08:44:00 -0400 (AST)
Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1])
	by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id i2GCj3Nu001613;
	Tue, 16 Mar 2004 14:45:03 +0200
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id
	i2GCj3Cs001609; Tue, 16 Mar 2004 14:45:03 +0200
Date: Tue, 16 Mar 2004 14:45:03 +0200 (EET)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: beyaNet Consultancy <beyanet@ntlworld.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: could not create shared memory segment: Invalid argument
In-Reply-To: <E1E78611-7745-11D8-ACD7-0003938366A4@ntlworld.com>
Message-ID: <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/169
X-Sequence-Number: 17268

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