Re: [ADMIN] Postgres crash during low-traffic period, need advice.

work_mem is not set in the config file, so it's using the default setting.. On Mon, Dec 20, 2010 at 9:34 AM, Scott Marlowe wrote: > On Mon, Dec 20, 2010 at 6:41 AM, Benoit Clennett-Sirois > wrote: >> Hi, >> >> We have a front-end server taking care of Nginx, memc

Re: [ADMIN] Postgres crash during low-traffic period, need advice.

On Mon, Dec 20, 2010 at 9:29 AM, wrote: > Zitat von Benoit Clennett-Sirois : > >> Hi, >> >> We have a front-end server taking care of Nginx, memcached and >> Postgresql. Last night the postgres daemon crashed (traffic was very >> low at that time) with the fol

[ADMIN] Postgres crash during low-traffic period, need advice.

Hi, We have a front-end server taking care of Nginx, memcached and Postgresql. Last night the postgres daemon crashed (traffic was very low at that time) with the following error: 2010-12-20 03:34:30 EST DETAIL:  Failed system call was shmget(key=5432001, size=1124474880, 03600). 2010-12-20 03:34