| From: | Tod McQuillin <devin(at)spamcop(dot)net> |
|---|---|
| To: | Graham White <gawhite7(at)home(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Repairing table corruption |
| Date: | 2001-09-10 06:25:19 |
| Message-ID: | 20010910152210.F89526-100000@glass.pun-pun.prv |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jefim Matskin | 2001-09-10 07:31:03 | FW: a plpgsql programming question |
| Previous Message | Graham White | 2001-09-10 05:03:44 | Repairing table corruption |