Re: panic during pgsql startup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: igor(at)carcass(dot)ath(dot)cx
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: panic during pgsql startup
Date: 2006-03-10 15:08:30
Message-ID: 5354.1142003310@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

igor(at)carcass(dot)ath(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2006-03-10 15:46:39 About updates
Previous Message igor 2006-03-10 14:57:14 panic during pgsql startup