Thread: No postgres on Solaris

No postgres on Solaris

From
"Martin A. Marques"
Date:
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
-----------------------------------------------------------------

Re: No postgres on Solaris

From
Chris Jones
Date:
"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.

Re: No postgres on Solaris

From
"Martin A. Marques"
Date:
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
-----------------------------------------------------------------

Re: No postgres on Solaris

From
Peter Eisentraut
Date:
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/


Re: No postgres on Solaris

From
oberpwd@anubis.network.com (Wade D. Oberpriller)
Date:
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
> -----------------------------------------------------------------
>


Re: PostgreSQL v.7.0.2 for Windows 98,2000,NT

From
Chris Ian Capon Fiel
Date:

Sorry...that url for easy PostgreSQL (windowsm


Re: PostgreSQL for Windows 98, 2000, NT

From
Chris Ian Capon Fiel
Date:

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