Re: Fwd: Suspected Postgres Datacorruption

On 4/08/2011 1:14 AM, Sumeet Jauhar wrote:

> 1 . There was a system crash due to a hardware failure .

> A ) Isn’t Postgres database resilient enough to handle hardware system
> failure ? or it sometime results in a corrupt index for its tables ? I

You should *always* be able to pull the plug out of a box running Pg at
any point and have it come up just fine. If you can't, it's a bug. They
do turn up, but quite rarely and usually relating to odd corner cases in
newly introduced features.

If you've done something like turn off fsync, of course, you've just
told PostgreSQL "I don't care about my data, don't bother keeping it
crash safe" and you get garbage if there's a system crash. But that's
your choice to enable if your use case doesn't require data durability.
You haven't done that, so this isn't the cause of your issue.

The only other known case (in a current version) where index corruption
is expected after a crash is if you are using hash indexes. Hash indexes
are NOT CRASH SAFE, as per the documentation, and WILL need to be
reindexed after a crash. Don't use them unless you really know you need
them (you don't).

Of course, if you're using 7.4.2 or something ancient, you're missing a
lot of bug fixes, and some of them DID relate to data durability issues.

--
Craig Ringer