| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Cassiano, Marco" <mcassiano(at)manord(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Database in recovery mode forever |
| Date: | 2009-05-20 03:15:31 |
| Message-ID: | dcc563d10905192015v26a697b6k295556a88ff0f5f5@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, May 19, 2009 at 8:50 AM, Cassiano, Marco <mcassiano(at)manord(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnold, Sandra | 2009-05-20 20:51:53 | Audit Log Destination |
| Previous Message | Cassiano, Marco | 2009-05-19 14:50:07 | Database in recovery mode forever |