problems after server crash

From: Martin Würtele <martin(dot)wuertele(at)factline(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: problems after server crash
Date: 2001-10-25 15:53:49
Message-ID: 20011025175349.A22729@independence.wuertele.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hi,

1. unfortunately i can't subscribe to the mailinglist - it doesn't send me
the confirmation mail so please cc me.

2. 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)

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-10-25 16:53:52 Re: Bug #491: ERROR: RelationClearRelation: relation using JDBC
Previous Message Martin Würtele 2001-10-25 15:51:57 postgres crash