In order to get postgres working in concert with an iSight on a
PowerBook, I had to increase shmmax, and it seemed to work just fine
by editing /etc/rc:
sysctl -w kern.sysv.shmmax=134217728 kern.sysv.shmmin=1
kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=1024
After restarting, I have:
# sysctl -a | grep shm
kern.sysv.shmmax: 134217728
kern.sysv.shmmin: 1
kern.sysv.shmmni: 32
kern.sysv.shmseg: 8
kern.sysv.shmall: 1024
Of course, this still doesn't seem to be enough to let postgres play
nicely with the iSight...
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)
On Aug 29, 2005, at 7:18 PM, Tom Lane wrote:
Has anyone been able to set kern.sysv.shmmax above 4MB at all in
latest
OS X? I just spent a while trying what seemed every possible
permutation of setting up /etc/sysctl.conf and editing /etc/rc
directly,
and it just fails (symptom: sysctl shows shmmax as -1, and Postgres
cannot start).
Grrr. Apple's been pretty lame about this from day one, but at least
it's been possible to do it one way or another.
(Curiously, it seems you can now change shmall after bootup in 10.4.2,
but that's not much help when you can't change shmmax.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
