From: | Felde Norbert <fenor77(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | postgres crash SOS |
Date: | 2010-06-16 23:55:22 |
Message-ID: | AANLkTikepWH2_XlLaJv1b3LP6OljlI3H2Rm3xDebXUFn@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-06-17 00:16:41 | Re: postgres crash SOS |
Previous Message | Adrian Klaver | 2010-06-16 22:14:12 | Re: Dynamic triggers |