Re: Known issue with Reindex-based corruption?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Known issue with Reindex-based corruption?
Date: 2004-02-26 18:03:00
Message-ID: 200402261003.00829.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-02-26 18:05:49 Re: Known issue with Reindex-based corruption?
Previous Message Tom Lane 2004-02-26 17:55:58 Re: Known issue with Reindex-based corruption?