Skip site navigation (1) Skip section navigation (2)

Re: could not create shared memory segment: Invalid argument

From: xvx <xvx(dot)13l39y(at)mail(dot)webservertalk(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: could not create shared memory segment: Invalid argument
Date: 2004-03-23 18:30:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-sql
I'am also getting this same problem with 10.3.3 Server.  Worked fine
with 10.3.2.

kern.sysv.shmmax: 4194304
kern.sysv.shmmin: 1
kern.sysv.shmmni: 32
kern.sysv.shmseg: 8
kern.sysv.shmall: 1024

Those are the Values i get from the command posted.  Have you figured
out a fix for this error?


beyaNet Consultancy wrote:
> *Hi,
> I have just installed the latest version of OS X panther (10.3.3)
> and
> am now getting the following error message:
> 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
> 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 *

Posted via
View this thread:

In response to

pgsql-bugs by date

Next:From: PostgreSQL Bugs ListDate: 2004-03-23 23:15:00
Subject: BUG #1111: documentation error
Previous:From: pgsql-bugsDate: 2004-03-23 15:19:40
Subject: Returned due to virus; was:Mail Delivery (failure

pgsql-sql by date

Next:From: BillDate: 2004-03-23 18:51:23
Subject: Re: Database reporting tool
Previous:From: Stephan SzaboDate: 2004-03-23 17:22:29
Subject: Re: fine grained trigger time specification...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group