IPC Shared Memory (fwd)
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
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)