Re: shmget fails on OS X with proper settings

Martin:

They didn't take any memory out of the machine.  AS for memory cache
parameters, I'm don't know about that.  How would I go checking for
that type of thing?

Thanks,
Chris

On 5/6/07, Martin Gainty <mgainty@hotmail.com > wrote:
> 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.christopher.s@gmail.com >
> To: <pgsql-general@postgresql.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/
> >
>
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend