I don't think its pgsql thats sending the SIGKILL its being done by the OS. The reason can only be confirmed after looking at your log files but the probability is that your OS ran out of memory and in order to protect itself it had to kill the processes that were taking a lot of memory thus ended up killing pgsql processes. Its just a hunch that i have but the reason can only be confirmed after seeing your logs.
On Wednesday November 8 2006 12:30 pm, Shoaib Mir wrote: > To be specific you need to look at the syslogs to see if it > was actually some OOM killer or not.
I checked all db logs + syslog, of course. All they show is the process receiving SIGKILL (followed by all others being shutdown as a result).
Is there any circumstance at all under which pgsql itself would issue a sigkill to one of the backends?