panic during pgsql startup
Message-ID: 11616
Hi All,
I can't start postgresql. I'm getting:
PANIC: failed to re-find parent key in "17497"
in serverlog.
It's PostgreSQL v8.1.3 on Fedora Core 4, ~15g database. Is there any way do dump my data and/or fix it ? I do have a backup, and this is probably a problem w/ my hdd/memory, but still it'd be interesting to know which options do I have in such situation.
--
Best Regards,
Igor Shevchenko
igor@carcass.ath.cx writes:
I can't start postgresql. I'm getting:
PANIC: failed to re-find parent key in "17497"
in serverlog.
Is this happening during WAL replay? If so, you could probably get
the database to start by doing pg_resetxlog. No guarantees about how
consistent your data will be afterwards :-( ... but with a little luck
you'll be able to run pg_dump and compare with your backup. I'd
definitely recommend an initdb and reload after you get a dump that
seems sane.
regards, tom lane