Hi,
I have been using Postgres-7.0.2 on Solaris 8 for the past few months, and 
was about to upgrade to 7.1-test, and after following carefully the docs, I 
get this:

postgres@ultra31:~ > /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
IpcSemaphoreCreate: semget(key=5432004, 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.
 
postgres@ultra31:~ >  

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.

Any clues?

-- 
System Administration: It's a dirty job, 
but someone told I had to do it.
-----------------------------------------------------------------
Martï¿½n Marquï¿½s			email: 	martin@math.unl.edu.ar
Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Mon, 11 Dec 2000 12:07:01 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
No postgres on Solaris
"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.

12 Dec 2000 10:00:49 -0700
Chris Jones <chris@mt.sri.com>
Re: No postgres on Solaris
El Lun 11 Dic 2000 12:07, Martin A. Marques escribiï¿½:
> Hi,
> I have been using Postgres-7.0.2 on Solaris 8 for the past few months, and
> was about to upgrade to 7.1-test, and after following carefully the docs, I
> get this:
>
> postgres@ultra31:~ > /usr/local/pgsql/bin/postmaster -D
> /usr/local/pgsql/data IpcSemaphoreCreate: semget(key=5432004, num=17,
> 03600) failed: No space left on
> device

Sorry, checked the FAQ (I thought this would be in the FAQ_Solaris, but it 
was in the general), and I just recompiled without the --with-maxbackends=64, 
so I ran out of semaphores.

Fixed. ;-)

-- 
System Administration: It's a dirty job, 
but someone told I had to do it.
-----------------------------------------------------------------
Martï¿½n Marquï¿½s			email: 	martin@math.unl.edu.ar
Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Wed, 13 Dec 2000 11:41:47 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
Re: No postgres on Solaris
Martin A. Marques writes:

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

http://www.postgresql.org/devel-corner/docs/postgres/kernel-resources.htm#SYSVIPC

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Wed, 13 Dec 2000 18:58:12 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: No postgres on Solaris
I found it in the PostgreSQL Administrator manual under "Managing Kernel 
Resources".

Wade Oberpriller

> 
> Hi,
> I have been using Postgres-7.0.2 on Solaris 8 for the past few months, and 
> was about to upgrade to 7.1-test, and after following carefully the docs, I 
> get this:
> 
> postgres@ultra31:~ > /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
> IpcSemaphoreCreate: semget(key=5432004, 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.
>  
> postgres@ultra31:~ >  
> 
> 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.
> 
> Any clues?
> 
> -- 
> System Administration: It's a dirty job, 
> but someone told I had to do it.
> -----------------------------------------------------------------
> Martï¿½n Marquï¿½s			email: 	martin@math.unl.edu.ar
> Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------
> 


Wed, 13 Dec 2000 13:29:29 -0600 (CST)
oberpwd@anubis.network.com (Wade D. Oberpriller)
Re: No postgres on Solaris


Sorry...that url for easy PostgreSQL (windowsm


Thu, 14 Dec 2000 17:59:48 +0800 (PST)
Chris Ian Capon Fiel <ian@xavier.cc.xu.edu.ph>
Re: PostgreSQL v.7.0.2 for Windows 98,2000,NT


Sorry for the website is not accessble that time .... but now it can be
access at this url http://208.160.255.143

this include an easy installation of PostgreSQL v.7.0.2 for windows
98,2000 and NT. there is a pg guardian that automatically start and setup
ur server and many more...:) hope you like this piece of program....


ian


Thu, 14 Dec 2000 18:11:31 +0800 (PST)
Chris Ian Capon Fiel <ian@xavier.cc.xu.edu.ph>
Re: PostgreSQL for Windows 98, 2000, NT