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

Re: SHMMAX seems entirely broken in OS X 10.4.2

From: Jeff Trout <threshar(at)torgo(dot)978(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SHMMAX seems entirely broken in OS X 10.4.2
Date: 2005-08-30 12:28:18
Message-ID: 732F80DB-AF44-4FDD-B013-66C9CC3975AA@torgo.978.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Aug 30, 2005, at 12:37 AM, Tom Lane wrote:

>
> Did that.  Set shmall first, shmall second, both together in one  
> sysctl
> command; no joy anywhere.  Are you trying this on fully up-to-date
> Tiger?
>

Just ran software update and (besides a couple apps) it had a  
security update.

skittlebrau:~ postgres$ grep shm /etc/rc
# sysctl -w kern.sysv.shmmax=4194305 kern.sysv.shmmin=1  
kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=1024
sysctl -w kern.sysv.shmmax=335544320
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=16
sysctl -w kern.sysv.shmall=327680

skittlebrau:~ postgres$ sysctl -a | grep shm
kern.sysv.shmmax: 335544320
kern.sysv.shmmin: 1
kern.sysv.shmmni: 32
kern.sysv.shmseg: 16
kern.sysv.shmall: 327680

good luck.

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



In response to

Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2005-08-30 13:17:42
Subject: Re: ALTER TABLE ( smallinto -> boolean ) ...
Previous:From: Andrew DunstanDate: 2005-08-30 12:25:01
Subject: Re: PG_DUMp

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