Re: unexpected shutdown - Mailing list pgsql-general

From Tom Lane
Subject Re: unexpected shutdown
Date
Msg-id 4003.1182197958@sss.pgh.pa.us
Whole thread Raw
In response to unexpected shutdown  (developer@wexwarez.com)
Responses Re: unexpected shutdown
List pgsql-general
developer@wexwarez.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: time without time zone
Next
From: Tom Lane
Date:
Subject: Re: pg_restore out of memory