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/
> >
>
>
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 |