Re: Recovering data from corrupted table. Urgent Help!!

ruben wrote:
> Hi Gaetano:
>
> This procedure to recover data from a corrupted table should be
> documented somewhere... If it is, I could not find it!

First of all the table was not corrupted, the glitch was in another
subsystem.
The procedure is documented in the archives :-(

I agree with you but any cure seems worst then the disease. You have understand
why the file 0004 was not anymore there, did you had a power failure for
example ?

> Now I wonder if I have lost any data, because after creating the
> pg_clog/0004 and running VACCUM everything seems ok.

Normally you didn't lost any data.

Regards
Gaetano Mendola

PS: I had the same error for the first time in my postgres usage life
only after ( some weeks after ) having upgrade from a 7.4.2 -> 7.4.5