Subject: Re: Kernel Config - SHMMAXPGS FIXED
To: None <prlw1@newn.cam.ac.uk>
From: Ian Harding <ianh@tpchd.org>
List: port-i386
Date: 02/04/2004 12:35:34
I forgot step 8 after re-editing my kernel config file...
# "config <MYCONF>"
This will generate the kernel build directory for <MYCONF>.
I guess I thought "Well, I've already done that..." Oh well, now I know! =
My kernel is happy now. Thanks!!
<<< Patrick Welche <prlw1@newn.cam.ac.uk> 2/ 4 6:16a >>>
On Mon, Feb 02, 2004 at 12:34:50PM -0800, Ian Harding wrote:
> I have compiled a kernel having made the following changes to my=20
> configuration
>=20
> < #options SEMMNI=3D10 # number of semaphore identifiers
> < #options SEMMNS=3D60 # number of semaphores in system
> < #options SEMUME=3D10 # max number of undo entries per =
process
> < #options SEMMNU=3D30 # number of undo structures in system
> ---
> > options SEMMNI=3D256 # number of semaphore identifiers
> > options SEMMNS=3D512 # number of semaphores in system
> > options SEMUME=3D40 # max number of undo entries per =
process
> > options SEMMNU=3D256 # number of undo structures in system
> 80c80
> < #options SHMMAXPGS=3D1024 # 1024 pages is the default
> ---
> > options SHMMAXPGS=3D16192 # 1024 pages is the default
I think you are fine:
Just for reference my configuration says:
options SHMMAXPGS=3D32768 # 2048 pages is the default
# PostgreSQL notes:
#options SHMMAXPGS=3D8192 # (2048) 512 kB + 8192 * buffers + extra
#options SEMMNI=3D64 # (10) >=3D ceil(max_connections / 16)
#options SEMMNS=3D256 # (60) ceil(max_connections / 16) * 17 + extra
(on i386, 1 page =3D 4k)
You have 1000 buffers, 16 connections, so
512 kB + 8k * 1000 buffers =3D 8512kB =3D 2128 pages < 16192 pages as =
configured.
> IpcMemoryCreate: shmget(key=3D5432001, size=3D10035200, 03600) failed:=20=
and size < 16192*4k
So, could it be that your pages are still in use? eg., if you switch off
the postmaster, does
ipcs -a
still show you entries for postgres? (ipcrm lets you clear them)
Cheers,
Patrick
=20