From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | "ruben20(at)superguai(dot)com" <ruben20(at)superguai(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Recovering data from corrupted table. Urgent Help!! |
Date: | 2004-10-13 15:21:35 |
Message-ID: | 20041013152134.GC27652@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)superguai(dot)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
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Ted Shab | 2004-10-13 15:32:04 | Re: LISTEN/NOTIFY for lightweight replication |
Previous Message | Alexander Cohen | 2004-10-13 15:17:00 | ODBC |