Re: SEMMNI,SEMMNS config for posgres 7.1 under Solaris

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