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
Date: Tue, 16 Mar 2004 14:45:03 +0200 (EET)
Message-ID: <Pine.LNX.4.44.0403161442500.1464-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <E1E78611-7745-11D8-ACD7-0003938366A4@ntlworld.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, beyanet@ntlworld.com
Subject: Re: could not create shared memory segment: Invalid argument
In-Reply-To: <Pine.LNX.4.44.0403161442500.1464-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox