SEMMNI,SEMMNS config for posgres 7.1 under Solaris

From: Eric Scroger <escroger(at)carl(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: SEMMNI,SEMMNS config for posgres 7.1 under Solaris
Date: 2002-03-04 23:44:20
Message-ID: 3C8406D4.1030200@carl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

I need help configuring SEMMNI and SEMMNS for postgres 7.1 under Solaris.
We are upgrading from postgres 6.4 to 7.1. When I start postmaster, I get
the following error message in postmaster.out:

--------------
IpcSemaphoreCreate: semget(key=5432002, num=17, 03600) failed: No space
left on device

This error does *not* mean that you have run out of disk space.

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 did a little surfing on the web and found this page on the postgresql site
which suggests how to configure Solaris' /etc/system file to handle this
problem.

http://developer.postgresql.org/docs/postgres/kernel-resources.html

Basically, it appears you add the following lines to /etc/system and reboot.

------------
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
---------------

Well, I tried that and I still get that same error message. Any other
ideas?

Thanks in advance,

Eric Scroger

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jon Hassen 2002-03-05 00:29:38 index item size 4496 exceeds maximum 2713
Previous Message Naomi Walker 2002-03-04 20:08:15 Re: long vacuum