Re: Error while trying to back up database: out of memroy

On Sun, Sep 28, 2008 at 2:18 AM, Peter Kovacs
<peter(dot)kovacs(dot)1(dot)0rc(at)gmail(dot)com> wrote:
> On Mon, Sep 22, 2008 at 4:43 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> "Vladimir Rusinov" <vladimir(at)greenmice(dot)info> writes:
>>> But now I'm getting following error:
>>> pg_dump: WARNING: terminating connection because of crash of another server
>>> process
>>
>> As a rule of thumb, you should disable OOM kill on any server system.
>
> This document describes a few solutions potentially better than
> outright disabling:
> http://www.redhat.com/archives/taroon-list/2007-August/msg00006.html .
> (I don't know whether those solutions actually work or not, but may be
> worth trying by the look of it.)

While there are better solutions for other types of servers, like web
servers and what not, for PostgreSQL servers, overcommit isn't usually
needed, and OOM killer / overcommit can both be disabled.