Re: hot restart of posgtresql

ngaleyev@wavelengthmail.com 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