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