Re: Reasons for postgres processes beeing killed by SIGNAL 9?

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Reasons for postgres processes beeing killed by SIGNAL 9?
Date: 2012-05-22 16:53:47
Message-ID: 3605585.hDLB9QBq9s@skynet.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, May 19, 2012 04:42:16 PM Clemens Eisserer wrote:
> Hi again,
>
> We are still constantly getting postgresql processes killed by signal
> 9 from time to time, without any idea why or how.
> Syslog seems completly clean.
>
> In case a postgresql process would exceed some restricted resources
> like file descriptors, would the kernel choose to terminate it using
> SIGKILL? Are there any other common examples / occurences where
> processes are terminated this way automatically?

Check dmesg or the kernel log. I'd guess it's the OOM-killer. Assuming this is
on Linux, that is.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2012-05-22 18:20:54 Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1
Previous Message David Kerr 2012-05-22 16:36:13 haproxy / pgpool / rhcs