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 -- Martijn van Oosterhout <[EMAIL PROTECTED]> 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.
pgpOOY3ikI4zN.pgp
Description: PGP signature
