Hi all, I use 8.2 on a windows server 2008. Suddenly postgres crashed and I can not do anything. The message is Could not access status of transaction 3982736. DATAIL: Could not read from file "pg_clog/0003" at offset 204800: No error. The only one thing I found to correct this is to create a file filled with binary 0 and replace clog/0003. Both files size are the same. I tried that but I am still not able to run vacuum. I tried even with a bigger empty clog/0003 file, but nothing. I tried to drop the last few transaction with pg_resetxlog and hoped I can save some data, but the service wont start. The last error message is: ERROR: could not create relation 1663/0/1224: File exists. I looked for base/1224/0/1663, base/1663/1224/0 and base/1663/0/1224 file but there is no such file. Can anyone suggest something? Many data would be lost if I can not repaire that so please! Thanks, fenor -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
