Thread: BUG #1014: postgres crash

BUG #1014: postgres crash

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1014
Logged by:          vidhya
Email address:      vidhyabhaskaran@yahoo.co.in
PostgreSQL version: 7.3.3
Operating system:   windows2000
Description:        postgres crash
Details:

Hi,

Due to overload postgres crashes often. I am getting the following error

IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Not enough core

I want to increase the SHMMAX parameter in kernel.

I read the PG documents. They suggested to change the parameter in shm.h file.

They told that SHMMAX parameter is defined in shm.h as
“#define SHMMAX 0x2000000.”

But i couldn't find such an entry in that file.

Can u suggest me a solution for this?