Re: table corruption

Thilo,

> The same happens to anything above 152239. (well, i didnt tried all...)
> The first (regarding to the tabledefinition) 2 fields of row 152239 can be
> viewed. Querying other rows show the above error.
> There is no index on the table. Is there something i can do to rescue the
> data?

First, make a copy of your files for this table ASAP, preferably to another
HDD or another machine. If you can't figure out which files they are,
simple shut down PostgreSQL and back up the whole $PGDATA/base directory,
which might be a good idea in any case.

I've seen the symptoms you describe in 2 cases:
1) A bad sector on your hard drive;
2) systems where unexpected power-outs occur frequently.

So the next thing to do is to run some kind of exhaustive HDD scan for bad
sectors, and possibly replace the HDD.

Finally, I take it from your e-mail that you don't have a backup of the
database. While there are several tools to help you scan & read and find
corruption in postgresql files in your /contrib source, I'm not sure that any
of them will allow you to recover your data for the affected records.

--
Josh Berkus
Aglio Database Solutions
San Francisco