Re: postmaster segfault when using SELECT on a table - Mailing list pgsql-bugs

From Karsten Desler
Subject Re: postmaster segfault when using SELECT on a table
Date
Msg-id 20080429115140.GI24990@soohrt.org
Whole thread Raw
In response to Re: postmaster segfault when using SELECT on a table  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
List pgsql-bugs
* Zdenek Kotala wrote:
> Karsten Desler wrote:
> >
> >I don't know much about the postgres architecture and I don't know if
> >bounds
> >checking on-disk values on a read makes a lot of sense since usually one
> >should be able to assume that there are no randomly flipped bits; but it
> >would've been nice to have a sensible log entry as to what really
> >happened.
>
> I attached backported patch from head to 8.2. You can try it. It has small
> performance penalty, but it does not crash on corrupted data.

Thank you very much! I have restored a backup of the corrupt postgres
data files on a second server and I can confirm that postmaster no
longer crashes with the patch applied.

Thanks,
 Karsten

pgsql-bugs by date:

Previous
From: Sam Mason
Date:
Subject: Re: PB with postgresql 7.4
Next
From: "Kirill Simonov"
Date:
Subject: BUG #4132: REASSIGN OWNED fails on procedural languages