Re: shmget problem on solaris

You need to check into setting the following values in /etc/system

set shmsys:shminfo_shmmax = 16000000
set shmsys:shminfo_shmmin = 1
set shmsys:shminfo_shmmni = 100
set shmsys:shminfo_shmseg = 20
set semsys:seminfo_semmns = 200
set semsys:seminfo_semmni = 70

This is how mine is currently set. It probably isn't optimal but it gets
the job done.  :)


qradius@qnet.com.pe wrote:

>Dear Sirs:
>
>Please I have a problem at attempting  to run postmaster on
>Solaris
>
>when I executed:
>
>/usr/local/pgsql/bin/postmaster -i -D  /usr/local/pgsql/data
>
>I get the follow error:
>
>This error can be caused by one of three things:
>
>1. The maximum size for shared memory segments on your system
>was
>   exceeded.  You need to raise the SHMMAX parameter in your
>kernel
>   to be at least 1245184 bytes.
>
>2. The requested shared memory segment was too small for your
>system.
>   You need to lower the SHMMIN parameter in your kernel.
>
>3. The requested shared memory segment already exists but is
>of the
>   wrong size.  This is most likely the case if an old
>version of
>   PostgreSQL crashed and didn't clean up.  The `ipcclean'
>utility
>   can be used to remedy this.
>
>I am running Soalris v SunOS 5.8 , what possible solutions
>exists?
>
>Thank you in advance
>
>Ernesto
>
>
>---------------------------------------------
>Este mensaje fue enviado a través de Qnet
>http://www.qnet.com.pe
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
cd /pub
more beer