Re: shmget fails on OS X with proper settings

From: "Martin Gainty" <mgainty(at)hotmail(dot)com>
To: "Christopher S Martin" <martin(dot)christopher(dot)s(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: shmget fails on OS X with proper settings
Date: 2007-05-06 21:41:45
Message-ID: BAY133-DAV42F68FDE0336E62BD9AA5AE460@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

if you're getting memory errors then a guess would be did they take out any
memory out of your machine or perhaps did they change your memory cache
parameters???
Martin
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.

----- Original Message -----
From: "Christopher S Martin" <martin(dot)christopher(dot)s(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, May 06, 2007 3:07 PM
Subject: [GENERAL] shmget fails on OS X with proper settings

> Hi to the list, its my first post.
>
> I was previous running postgres 8.2.1 on my OS X 10.4.9 laptop with no
> problems.
> After I sent it to apple care, I found that I can no longer start the
> postmaster daemon. When I try, I receive the standard shmget failed
> error message:
>
> FATAL: could not create shared memory segment: Cannot allocate memory
> DETAIL: Failed system call was shmget(key=5432001, size=4112384, 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 4112384 bytes), reduce PostgreSQL's
> shared_buffers parameter (currently 300) and/or its max_connections
> parameter (currently 30).
>
> I get this error with either the settings recommended on the kernel
> resources page:
>
> kern.sysv.shmmax=4194304
> kern.sysv.shmmin=1
> kern.sysv.shmmni=32
> kern.sysv.shmseg=8
> kern.sysv.shmall=1024
>
> And I also get it when i set kern.sysv.shmmax=12582912
>
> After making all these changed rebooting doesn't fix anything.
>
> Has anyone ran into this problem, or has any idea as to why this would
> start to fail so suddenly?
>
> Thanks,
> Chris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sinead O Brien 2007-05-06 22:05:02 did not find any relation for existing table
Previous Message Christopher S Martin 2007-05-06 19:07:33 shmget fails on OS X with proper settings