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

From Tom Lane
Subject Re: Known issue with Reindex-based corruption?
Date
Msg-id 9193.1077772317@sss.pgh.pa.us
Whole thread Raw
In response to Known issue with Reindex-based corruption?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Known issue with Reindex-based corruption?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-bugs
Josh Berkus <josh@agliodbs.com> writes:
> Is there any known issues with index file corruption in the event of a
> power-out during REINDEX with 7.2.4?

There's been a lot of water over the dam since 7.2.4.  I'd suggest
offering more details if you want an informed comment.

One question that comes to mind is were you reindexing a system or user
table?  Another is whether you were using disks that lie about write
completion (SCSI vs IDE)?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Shelby Cain
Date:
Subject: Re: ecpg mapping struct members for indicators incorrectly?
Next
From: merino silva
Date:
Subject: lock mode in DELETE