Re: [SQL] could not create shared memory segment: Invalid argument

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 <achill(at)matrix(dot)gatewaynet(dot)com>
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