Thread: Repairing table corruption

Repairing table corruption

From
"Graham White"
Date:
We are looking at moving from a Mysql database setup and we understand
that table corruption in Postgres is a lot less likely but if it does
happen are there built in utilities to repair the tables? Recommended
3rd party products?  Thanks
GW


Re: Repairing table corruption

From
Tod McQuillin
Date:
On Sun, 9 Sep 2001, Graham White wrote:

> We are looking at moving from a Mysql database setup and we understand
> that table corruption in Postgres is a lot less likely but if it does
> happen are there built in utilities to repair the tables? Recommended
> 3rd party products?  Thanks

If your table data becomes corrupted, then you really can't trust the data
contained there, and there's no way (in general) that any utility can
guess what the data should be.  In this case the only safe course is to
restore from backups.

This should be true for any databse product, but perhaps mysql is known to
fail in specific ways that a certain type of cleanup can repair.  I'm not
aware of any such known corruption patterns in PostgreSQL.
--
Tod McQuillin