Re: SEMMNI,SEMMNS config for posgres 7.1 under Solaris

From: Eric Scroger <escroger(at)carl(dot)org>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: SEMMNI,SEMMNS config for posgres 7.1 under Solaris
Date: 2002-03-05 00:36:56
Message-ID: 3C841328.1030107@carl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey again.

Well I got some help from someone on the list already.
Turns out shared_buffers was commented out of postgresql.conf.
I set shared_buffers to 32 and max_connections to 16 just to
try it and it appeared to work.

Thanks to all.

Eric

Eric Scroger wrote:

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sean Chittenden 2002-03-05 04:16:42 Re: [ADMIN] password change...
Previous Message Jon Hassen 2002-03-05 00:29:38 index item size 4496 exceeds maximum 2713