Re: unexpected shutdown

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: developer(at)wexwarez(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unexpected shutdown
Date: 2007-06-18 20:19:18
Message-ID: 4003.1182197958@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

developer(at)wexwarez(dot)com writes:
> My database has shutdown several times in the last couple days. I have no
> idea why. I am running centos and I have not rebooted the server or made
> any configuration changes.

So in particular, you didn't disable memory overcommit?

> LOG: server process (PID 501) was terminated by signal 9

If you didn't issue a manual kill -9, then this is almost certainly a
trace of the kernel OOM killer at work. Google for "OOM kill" to learn
more, or see "memory overcommit" in the PG docs.

Memory overcommit is evil on a server.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-06-18 20:21:30 Re: pg_restore out of memory
Previous Message Tom Lane 2007-06-18 20:15:36 Re: time without time zone