pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedIPC Shared Memory (fwd)
2+ messages / 2 participants
[nested] [flat]
* IPC Shared Memory (fwd)
@ 2001-02-26 05:06 Katsuyuki Tanaka <katsut@cse.unsw.EDU.AU>
0 siblings, 1 reply; 2+ messages in thread
From: Katsuyuki Tanaka @ 2001-02-26 05:06 UTC (permalink / raw)
To: pgsql-general@postgresql.org; +Cc: pgsql-hackers@postgresql.org; pgsql-interfaces; pgsql-admin@postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] IPC Shared Memory (fwd)
@ 2001-02-26 08:51 Peter Schindler <pschindler@synchronicity.com>
parent: Katsuyuki Tanaka <katsut@cse.unsw.EDU.AU>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Schindler @ 2001-02-26 08:51 UTC (permalink / raw)
To: Katsuyuki Tanaka <katsut@cse.unsw.EDU.AU>; +Cc: pgsql-general@postgresql.org; pgsql-admin@postgresql.org
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)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-02-26 08:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-26 05:06 IPC Shared Memory (fwd) Katsuyuki Tanaka <katsut@cse.unsw.EDU.AU>
2001-02-26 08:51 ` Peter Schindler <pschindler@synchronicity.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox