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 <[EMAIL PROTECTED]> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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, [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: 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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
