Joined: 14 May 2002
Location: Milwaukee, WI
|Posted: Thu Jun 26, 2003 1:32 pm Post subject: Got postgres working but...
|I had to change the defaults in conf.d which where:
PGOPTS="-i -N 1024 -B 2048"
PGOPTS="-i -N 512 -B 1024"
It's weird because on a PIII 500 with 128mb of ram the defaults work fine.
I also checked the shmmax shared mem size and it was set to the same as the PIII box.
This is the error i would get in the postgres log(with the default settings):
IpcMemoryCreate: shmget(key=5432001, size=34275328, 03600) failed: Invalid argument
This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter. You can either
reduce the request size or reconfigure the kernel with larger SHMMAX.
To reduce the request size (currently 34275328 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 2048) and/or
its max_connections parameter (currently 1024).
If the request size is already small, it's possible that it is less than
your kernel's SHMMIN parameter, in which case raising the request size or
reconfiguring SHMMIN is called for.
The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.