No postgres on Solaris
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
-----------------------------------------------------------------
"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.
Import Notes
Reply to msg id not found: MartinA.MarquessmessageofMon11Dec2000120701-0300
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
-----------------------------------------------------------------
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/
I found it in the PostgreSQL Administrator manual under "Managing Kernel
Resources".
Wade Oberpriller
Show quoted text
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
deviceThis 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
-----------------------------------------------------------------
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