Recovering data from corrupted table. Urgent Help!! - Mailing list pgsql-general

From ruben20@superguai.com
Subject Recovering data from corrupted table. Urgent Help!!
Date
Msg-id 416D3415.10205@superguai.com
Whole thread Raw
Responses Re: Recovering data from corrupted table. Urgent Help!!
Re: Recovering data from corrupted table. Urgent Help!!
List pgsql-general
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:  could not open file "/usr/local/pgsql/data/pg_clog/0004": No
existe el fichero o el directorio

Thanks a lot.



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Proposal: GRANT cascade to implicit sequences
Next
From: David Rysdam
Date:
Subject: Date format for bulk copy