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