You must edit the file /etc/rc ( sudo pico /ect/rc ) find the system tuning section and change as follows:
sysctl -w kern.sysv.shmmax=167772160 sysctl -w kern.sysv.shmmin=1 sysctl -w kern.sysv.shmmni=32 sysctl -w kern.sysv.shmseg=8 sysctl -w kern.sysv.shmall=65536 warning... this change will not survive a system update that updates the /etc/rc file. Ted --- Achilleus Mantzios <[EMAIL PROTECTED]> wrote: > O kyrios beyaNet Consultancy egrapse stis Mar 16, > 2004 : > > > Hi, > > I have just installed the latest version of OS X > panther (10.3.3) and > > am now getting the following error message: > > For start do: > > sysctl -a | grep -i shm > or equivalent to find out your current kernel > settings. > > in FreeBSD the way to change shmmax is > > # sysctl sysctl kern.ipc.shmmax=<some size> > > I dont know about OSX tho.. > > > > > postgres$ /usr/local/pgsql/bin/postmaster -i -D > /usr/local/pgsql/data > > FATAL: could not create shared memory segment: > Invalid argument > > DETAIL: Failed system call was > shmget(key=5432001, size=10444800, > > 03600). > > HINT: This error usually means that PostgreSQL's > request for a shared > > memory segment exceeded your kernel's SHMMAX > parameter. You can either > > reduce the request size or reconfigure the kernel > with larger SHMMAX. > > To reduce the request size (currently 10444800 > bytes), reduce > > PostgreSQL's shared_buffers parameter (currently > 1000) and/or its > > max_connections parameter (currently 100). > > If the request size is already small, > it's possible that it is > > less than your kernel's SHMMIN parameter, in which > case raising the > > request size or reconfiguring SHMMIN is called > for. > > The PostgreSQL documentation contains > more information about > > shared memory configuration. > > > > Any ideas on how i can resolve this issue? > > > > many thanks in advance > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > -- > -Achilleus > > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings __________________________________ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
