RE: [HACKERS] postmaster failure with 2-23 snapshot - Mailing list pgsql-hackers

From Daryl W. Dunbar
Subject RE: [HACKERS] postmaster failure with 2-23 snapshot
Date
Msg-id 004a01be5f96$78ef14a0$1445e59b@ddunbar.eni.net
Whole thread Raw
In response to Re: [HACKERS] postmaster failure with 2-23 snapshot  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

DwD

> -----Original Message-----
> From: owner-pgsql-hackers@postgreSQL.org
> [mailto:owner-pgsql-hackers@postgreSQL.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
>



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] postmaster failure with 2-23 snapshot
Next
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] inet data type regression test fails