Re: Database in recovery mode forever - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Database in recovery mode forever
Date
Msg-id dcc563d10905192015v26a697b6k295556a88ff0f5f5@mail.gmail.com
Whole thread Raw
In response to Database in recovery mode forever  ("Cassiano, Marco" <mcassiano@manord.com>)
List pgsql-admin
On Tue, May 19, 2009 at 8:50 AM, Cassiano, Marco <mcassiano@manord.com> wrote:
> Hi all,
>
> this afternoon I had a database crash on a test system (The first Postgres
> crash in more than three years).
> I wasn't able to identify the reason.....the log doesn't say anything
> interesting.
> Is there way the exactly identify the reason of the crash ?
> 2009-05-19 16:04:18 CEST    0 4a092d56.1535 - LOG:  server process (PID
> 22298) was terminated by signal 9: Killed
> 2009-05-19 16:04:18 CEST    0 4a092d56.1535 - LOG:  terminating any other
> active server processes

Postgres doesn't issue kill -9s.  Looks like the OOM killer got you.

pgsql-admin by date:

Previous
From: "Cassiano, Marco"
Date:
Subject: Database in recovery mode forever
Next
From: "Arnold, Sandra"
Date:
Subject: Audit Log Destination