Re: Known issue with Reindex-based corruption?

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