Postgres Pro
Downloads
Home   >   mailing lists

Re: How to repair Pg 9.1? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to repair Pg 9.1?
Date
Msg-id 8797.1334503873@sss.pgh.pa.us
Whole thread Raw
In response to How to repair Pg 9.1?  ("Dmitry E. Oboukhov" <unera@debian.org>)
Responses Re: How to repair Pg 9.1?  ("Dmitry E. Oboukhov" <unera@debian.org>)
List pgsql-general
Tree view 
"Dmitry E. Oboukhov" <unera@debian.org> writes:
> Recently I started a hard query (ALTER TABLE) and then Postgresql was
> killed by OOM killer.
> ...
>     2012-04-15 16:46:02 MSK LOG:  server process (PID 825) was terminated by signal 11: Segmentation fault

You sure it was an OOM kill?  The OOM killer does its dirty work with
signal 9 (SIGKILL), not signal 11 (SIGSEGV).

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Adams
Date:
Subject: Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
Next
From: "Dmitry E. Oboukhov"
Date:
Subject: Re: How to repair Pg 9.1?