Re: [QUESTIONS] Basic table repair info.
Thomas Lockhart <lockhart@alumni.caltech.edu>
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: GBNSCHBACH <GBNSCHBACH@aol.com>, Postgres Hackers List <hackers@postgresql.org>
Date: 1998-03-11T03:45:51Z
Lists: pgsql-hackers
> > I'd like to know what are the table repair tools. I examined a table with
> > od -c
> > and boy, that does not look like what I put in. So other than good old
> > fashioned backups, how do you rebuild a corrupted file ?
> > Just wonderin'
> We don't need no sinking repair tools. :-)
> Actually, we very rarely hear about any corruption problems, so there
> are no repair tools.
Well, I've been wondering the same thing. I guess no one has been caught badly
enough to write the tools. It seems like one project could be to write a "recover
mode" into the backend, which would allow pg_dump to run to completion even though
a table is damaged. Would need a command line switch (or an SQL command) and then
some checks in the backend to return gracefully rather than throw an error and
quit.
- Tom