Re: FW: psql error

archana shinde wrote:
> Please look at below mail and help me on this.

> Please could you help me to resolve this error which I am getting, I am using postgres 7.4.5 on
> solaris 9.

[...]

> 2013-03-28 20:00:12 FATAL: out of memory
> DETAIL: Failed on request of size 112.
[...]
> 2013-03-28 20:00:12 FATAL: out of memory
> DETAIL: Failed on request of size 1024.
> 2013-03-28 20:00:37 LOG: could not fork checkpoint process: Not enough space
> 2013-03-28 20:00:40 LOG: server process (PID 224) was terminated by signal 11
> 2013-03-28 20:00:40 LOG: terminating any other active server processes
> 2013-03-28 20:00:40 LOG: all server processes terminated; reinitializing
> 2013-03-28 20:00:41 FATAL: could not create shared memory segment: Not enough space
> DETAIL: Failed system call was shmget(key=5432001, size=118464512, 03600).
> HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded
> available memory or swap space
> . To reduce the request size (currently 118464512 bytes), reduce PostgreSQL's shared_buffers parameter
> (currently 14080) and/
> or its max_connections parameter (currently 40).
>
> The PostgreSQL documentation contains more information about shared memory configuration.

7.4 has been out of support for a while.

This looks like you cannot allocate enough shared memory.
If there is enough RAM in the machine, consider increasing
SHMALL (or maybe SHMMNI).

Yours,
Laurenz Albe