Re: Fw: Re: Recovering data from corrupted table. Urgent

Thanks Martijn:

It worked. I was having issues with 7.4.2, run memory ans disk checks
and hardware seems ok, that's why I decided to upgrade to 7.4.5, but
unfortunately I'm still experiencing data corruption.

Ruben.



ruben20 wrote:

> ---------- Forwarded Message -----------
> From: Martijn van Oosterhout <kleptog@svana.org>
> To: "ruben20@superguai.com" <ruben20@superguai.com>
> Sent: Wed, 13 Oct 2004 17:21:35 +0200
> Subject: Re: [GENERAL] Recovering data from corrupted table. Urgent Help!!
>
> 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, ruben20@superguai.com 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:  could not open file "/usr/local/pgsql/data/pg_clog/0004": No
>>existe el fichero o el directorio
>>
>>Thanks a lot.
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>              http://www.postgresql.org/docs/faqs/FAQ.html
>
>