Re: No postgres on Solaris - Mailing list pgsql-general

From Chris Jones
Subject Re: No postgres on Solaris
Date
Msg-id a5fu289d16m.fsf@merry.mt.sri.com
Whole thread Raw
In response to No postgres on Solaris  ("Martin A. Marques" <martin@math.unl.edu.ar>)
List pgsql-general
"Martin A. Marques" <martin@math.unl.edu.ar> writes:

> It occurs either because system limit for the maximum number of
> semaphore sets (SEMMNI), or the system wide maximum number of
> semaphores (SEMMNS), would be exceeded.  You need to raise the
> respective kernel parameter.  Look into the PostgreSQL documentation
> for details.
[...]
> I looked at the FAQ_Solaris, but found nothing on this case. I remember
> making changes to the kernel parameters when I fist installed postgres, but
> can't remember where I found that info.

I don't remember where on the PG site I found this, but this is what
I'm using currently:

set shmsys:shminfo_shmmax=0x2000000
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmseg=256
set semsys:seminfo_semmap=256
set semsys:seminfo_semmni=512
set semsys:seminfo_semmns=512
set semsys:seminfo_semmsl=32

These lines are all at the bottom of /etc/system.

Chris

--
----------------------------------------------------- chris@mt.sri.com
Chris Jones                                    SRI International, Inc.

pgsql-general by date:

Previous
From: Steve Heaven
Date:
Subject: Re: Sql query with partial matching
Next
From: "Edward Q. Bridges"
Date:
Subject: RE: Re: Unanswered questions about Postgre