From: | Martin Würtele <martin(at)wuertele(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | postgres crash |
Date: | 2001-10-25 15:51:57 |
Message-ID: | 20011025175157.A22636@independence.wuertele.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
hi,
we had a server crash today - had to fsck and postgres is corrupted now
if i try a pg_dump i get:
inetmain:/tmp/tests$ pg_dump -c -v -d factline1 > /tmp/factline1_20011025_144800.sql
-- saving database definition
getDatabase(): SELECT failed. Explanation from backend: 'ERROR: pg_atoi:
error in "t": can't parse "t"
'.
i get the same error if i try to dump a table.
i deleted all indexes as there were lot's of problems with them but this
didn't help ether.
i changed src/backend/access/transam/xlog.c
from
if (XLByteLT(LogwrtResult.Flush, record))
elog(STOP, "XLogFlush: request is not satisfied");
break;
to
if (XLByteLT(LogwrtResult.Flush, record))
elog(DEBUG, "XLogFlush: request (%u, %u) is not satisfied --- flushed to (%u, %u)",
record.xlogid, record.xrecoff,
LogwrtResult.Flush.xlogid, LogwrtResult.Flush.xrecoff);
break;
because otherwise postgres wouldn't even start.
my question: how can i either get a dump of my data or a running database
back. i did a backup of /var/lib/postgresql/data before removing indexes so
i still have the version after the crash.
tia martin
--
factline Krisper Fabro Harnoncourt OEG (www.factline.com)
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Würtele | 2001-10-25 15:53:49 | problems after server crash |
Previous Message | Tom Lane | 2001-10-25 14:12:14 | Re: Enabling --debug causes regression test failure. |