Re: shmget fails on OS X with proper settings

From: "Christopher S Martin" <martin(dot)christopher(dot)s(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: shmget fails on OS X with proper settings
Date: 2007-05-06 22:12:45
Message-ID: e3bfb7ba0705061512s67817e76i8ebfd4392f5e286b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)hotmail(dot)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(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 Glen Eustace 2007-05-06 22:39:03 Connections refused during backups
Previous Message Raymond O'Donnell 2007-05-06 22:11:51 Re: did not find any relation for existing table