Re: Known issue with Reindex-based corruption?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Known issue with Reindex-based corruption?
Date: 2004-02-26 05:11:57
Message-ID: 9193.1077772317@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message merino silva 2004-02-26 06:56:01 lock mode in DELETE
Previous Message Shelby Cain 2004-02-26 04:19:51 Re: ecpg mapping struct members for indicators incorrectly?