Re: Error while trying to back up database: out of memroy - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Error while trying to back up database: out of memroy
Date
Msg-id dcc563d10809290936g1e3085c1sa8b7fb87930cc07e@mail.gmail.com
Whole thread Raw
In response to Re: Error while trying to back up database: out of memroy  ("Peter Kovacs" <peter.kovacs.1.0rc@gmail.com>)
List pgsql-admin
On Sun, Sep 28, 2008 at 2:18 AM, Peter Kovacs
<peter.kovacs.1.0rc@gmail.com> wrote:
> On Mon, Sep 22, 2008 at 4:43 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> "Vladimir Rusinov" <vladimir@greenmice.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.

pgsql-admin by date:

Previous
From: "Peter Kovacs"
Date:
Subject: Re: Error while trying to back up database: out of memroy
Next
From: Andrew Sullivan
Date:
Subject: Re: turning of pg_xlog