Re: Known issue with Reindex-based corruption? - Mailing list pgsql-bugs

From Josh Berkus
Subject Re: Known issue with Reindex-based corruption?
Date
Msg-id 200402261003.00829.josh@agliodbs.com
Whole thread Raw
In response to Re: Known issue with Reindex-based corruption?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Known issue with Reindex-based corruption?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom,

> That's a definite possibility.  Before 7.4 we did not emit WAL records
> for data written during index build.  What we could have here is that
> the transaction completed and synced to WAL, but none of the data-file
> writes were sent to disk before power-out.  On restart, WAL replay would
> faithfully update the pg_class row, but the index file would still be
> empty :-(

Would this be back-patchable by a good PG hacker?   The client has $$$.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Known issue with Reindex-based corruption?
Next
From: Tom Lane
Date:
Subject: Re: Known issue with Reindex-based corruption?