From: Scott Marlowe <scott.marlowe@gmail.com>
To: Peter Kovacs <peter.kovacs.1.0rc@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Vladimir Rusinov <vladimir@greenmice.info>
Cc: pgsql-admin@postgresql.org
Subject: Re: Error while trying to back up database: out of memroy
Date: Mon, 29 Sep 2008 10:36:03 -0600
Message-ID: <dcc563d10809290936g1e3085c1sa8b7fb87930cc07e@mail.gmail.com> (raw)
In-Reply-To: <b6e8f2e80809280118r39b38e95rbbcc9dd5b8b54a38@mail.gmail.com>
References: <f6fdfb550809220709s3d736265y68b37358be8c8e2c@mail.gmail.com>
<16085.1222094580@sss.pgh.pa.us>
<b6e8f2e80809280118r39b38e95rbbcc9dd5b8b54a38@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, peter.kovacs.1.0rc@gmail.com, tgl@sss.pgh.pa.us, vladimir@greenmice.info
Subject: Re: Error while trying to back up database: out of memroy
In-Reply-To: <dcc563d10809290936g1e3085c1sa8b7fb87930cc07e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox