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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
