[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] postmaster segfault when using SELECT on a table
From:       Karsten Desler <kd () link11 ! de>
Date:       2008-04-29 11:51:40
Message-ID: 20080429115140.GI24990 () soohrt ! org
[Download RAW message or body]

* 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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]