Re: 7.2.3 -> 7.3.2: timeofday(), server crashed - Mailing list pgsql-admin

From Will LaShell
Subject Re: 7.2.3 -> 7.3.2: timeofday(), server crashed
Date
Msg-id 1049393583.22270.33.camel@lyric.ofsloans.com
Whole thread Raw
In response to Re: 7.2.3 -> 7.3.2: timeofday(), server crashed  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 7.2.3 -> 7.3.2: timeofday(), server crashed  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List pgsql-admin
<snip>
> > ERROR:  parser: parse error at or near "602869" at character 1
> > LOG:  server process (pid 31373) was terminated by signal 9
>
> This is also unrelated.  There is no scenario in which a parse error
> will lead to signal 9.  I would guess that you have one of the versions
> of Linux in which the kernel will issue kill -9's against
> randomly-selected user processes anytime it starts feeling low on
> memory.  Buying more RAM or increasing swap space is the best answer
> AFAIK.
>
>             regards, tom lane

As a side note it will show up in /var/log/messages  if the kernel is
doing the killing like Tom suggested.

Sincerely,
Will LaShell


Attachment

pgsql-admin by date:

Previous
From: Raquel Vieira
Date:
Subject: Vacuumdb
Next
From: Jodi Kanter
Date:
Subject: Re: Speed & Memory Management