

hi i'm re-sending this mail again to seek more help since i haven't got
any solution as yet. Additionaly , could it be an oracle taking up so much 
resource so that i postgres can't get any of them? 

Katsu

---------- Forwarded message ----------
Date: Sun, 18 Feb 2001 15:27:47 +1100 (EST)
From: Katsuyuki Tanaka <katsut@cse.unsw.EDU.AU>
To: pgsql-general@postgresql.org
Subject: IPC Shared Memory


	Hi when i run postmaster i got the following error and
	postmaser doesn't start,

	FATAL 1:  InitProcGlobal: IpcSemaphoreCreate failed
	IpcSemaphoreCreate: semget failed (No space left on device) key=8888014,
	num=16, permission=600
	This type of error is usually caused by an improper
	shared memory or System V IPC semaphore configuration.
	For more information, see the FAQ and platform-specific
	FAQ's in the source directory pgsql/doc or on our

	
	i made query to admin and the max shared mem setting is already
	set to the max possible

	*
	* IPC Shared Memory
	*
	4294967295      max shared memory segment size (SHMMAX)
     		1  min shared memory segment size (SHMMIN)
   		100  shared memory identifiers (SHMMNI)
    		10  max attached shm segments per process (SHMSEG)

	
	I tried -N and -B but didn't have luck. Could anyone help me on
	this? This problem appeared after admin changed their config 
	i believe, could that be it?

	Thanks
	Katsu



Mon, 26 Feb 2001 16:06:56 +1100 (EST)
Katsuyuki Tanaka <katsut@cse.unsw.EDU.AU>
IPC Shared Memory (fwd)
Katsu,

Katsuyuki Tanaka wrote:
> hi i'm re-sending this mail again to seek more help since i haven't got
> any solution as yet. Additionaly , could it be an oracle taking up so much
> resource so that i postgres can't get any of them?

Yes, I think your oracle db doesn't probably leave enough for PG.
I don't know how much of the shared resources are necessary for PG,
but I assume you have problems with the number of semaphores.

I had similar problems and I didn't want to reconfigure the systems, so I 
reduced the PROCESS parameter for oracle.

Have a look at the following description, on how to set and calculate the 
shared memory/semaphores for Oracle on UNIX (I assume you use Solaris):

http://otn.oracle.com/doc/solaris/server.815/a67457/pre.htm#1000595

That's the only version I found in HTML form, so if you have a different 
oracle version you might have to check your specific installation guide 
for that, but in principle the calculations are still the same for the 
different oracle versions, I think.

e.g. for 8.1.7 solaris
http://otn.oracle.com/docs/products/oracle8i/pdf/installguide_sun_817.pdf


>         i made query to admin and the max shared mem setting is already
>         set to the max possible
>         *
>         * IPC Shared Memory
>         *
>         4294967295      max shared memory segment size (SHMMAX)
>                 1  min shared memory segment size (SHMMIN)
>                 100  shared memory identifiers (SHMMNI)
>                 10  max attached shm segments per process (SHMSEG)
Yes, the (SHMMAX) seems to be max, but the others could be higher. The
same is true with the semaphore parameters. But those parameter influence quite
a bit how many resources are reserved from the kernel (-> needs memory)
So, the settings should balance your needs and available memory.

-- 
Best regards,
Peter Schindler	
   Synchronicity Inc.            |  pschindler@synchronicity.com
   http://www.synchronicity.com  |  +49 89 89 66 99 42 (Germany)

Mon, 26 Feb 2001 09:51:02 +0100
Peter Schindler <pschindler@synchronicity.com>
Re: [INTERFACES] IPC Shared Memory (fwd)