Skip site navigation (1) Skip section navigation (2)

RE: [HACKERS] postmaster failure with 2-23 snapshot

From: "Daryl W(dot) Dunbar" <daryl(at)www(dot)com>
To: "Brian P Millett" <bpm(at)ec-group(dot)com>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: RE: [HACKERS] postmaster failure with 2-23 snapshot
Date: 1999-02-24 01:39:09
Message-ID: 004a01be5f96$78ef14a0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Here is what I added to my /etc/system on Solaris 7:

set shmsys:shminfo_shmmax=16777216
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=128
set shmsys:shminfo_shmseg=51
set semsys:seminfo_semmap=128
set semsys:seminfo_semmni=128
set semsys:seminfo_semmns=8192
set semsys:seminfo_semmnu=8192
set semsys:seminfo_semmsl=64
set semsys:seminfo_semopm=32
set semsys:seminfo_semume=32

Of course, this is way more than you need to run 64 backends, this
will accommodate thousands of semaphores, but not much more than 128
backends due to the shared memory needs...  You might want to run a
sysdef to see the defaults first and then pick your tunables.


> -----Original Message-----
> From: owner-pgsql-hackers(at)postgreSQL(dot)org
> [mailto:owner-pgsql-hackers(at)postgreSQL(dot)org]On Behalf Of Tom Lane
> Sent: Tuesday, February 23, 1999 7:04 PM
> To: Brian P Millett
> Cc: pgsql-hackers
> Subject: Re: [HACKERS] postmaster failure with 2-23 snapshot
> > vlad: postmaster -i
> > IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> > size=1137426, permission=600
> I think shmget returns that error code when the requested size is
> larger than the system limit on shared memory block size.  Check
> your kernel parameters (SHMMAX and friends).
> You might find that starting the postmaster with a smaller value
> of -N is an easier answer than reconfiguring your kernel.
> 			regards, tom lane

In response to


pgsql-hackers by date

Next:From: Bruce MomjianDate: 1999-02-24 03:02:07
Subject: Re: [GENERAL] Transaction logging
Previous:From: Tom LaneDate: 1999-02-24 00:03:55
Subject: Re: [HACKERS] postmaster failure with 2-23 snapshot

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group