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
Hi Gaetano:
This procedure to recover data from a corrupted table should be
documented somewhere... If it is, I could not find it!
Now I wonder if I have lost any data, because after creating the
pg_clog/0004 and running VACCUM everything seems ok.
Thanks a lot for your help.
Ruben.
Gaetano Men
Create a file with that name filled with zeros with the same length as
the other files in that directory. That should get you far enough to
dump the data. Then run a complete set of memory and disk checks on
your system...
On Wed, Oct 13, 2004 at 02:56:37PM +0100, [EMAIL PROTECTED] wrote:
> Hi:
>
Gaetano Mendola wrote:
[EMAIL PROTECTED] wrote:
Hi:
Is there any way to recover data from a corrupted table? I can only
run SELECTs on certain WHERE conditions.
I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex,
always get error:
ERROR: could not access status of transactio
[EMAIL PROTECTED] wrote:
Hi:
Is there any way to recover data from a corrupted table? I can only run
SELECTs on certain WHERE conditions.
I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex,
always get error:
ERROR: could not access status of transaction 4244329
DETAIL: coul