ngaleyev@xxxxxxxxxxxxxxxxxx writes: > 2007-07-03 19:20:42 EDT 2928 FATAL: could not create shared memory > segment: Invalid argument > 2007-07-03 19:20:42 EDT 2928 DETAIL: Failed system call was > shmget(key=5432001, size=3276259328, 03600). > 2007-07-03 19:20:42 EDT 2928 HINT: 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 > 3276259328 bytes), reduce PostgreSQL's shared_buffers parameter (currently > 393216) and/or its max_connections parameter (currently 250). > heres my sysctl: > kernel.shmmax=4294967296 > kernel.shmall=536870912 Why have you got SHMALL set to half a GB when you have Postgres configured to ask for over 3 GB? regards, tom lane
