Re: Database corruption? - Mailing list pgsql-general

From Mikheev, Vadim
Subject Re: Database corruption?
Date
Msg-id 3705826352029646A3E91C53F7189E325183E0@sectorbase2.sectorbase.com
Whole thread Raw
In response to Database corruption?  (Alvaro Herrera <alvherre@atentus.com>)
List pgsql-general
> As I said to Denis in the earlier thread, it would be good to try to
> track down which page is corrupted and maybe then we'd understand how
> it got that way.  Since you have the database tarball, you have the
> raw material to look into it --- you'd need to rebuild Postgres with
> debug symbols enabled and trace back from the failure points to learn
> more.  Are you up to that, or could you grant access to your
> machine to someone who is?

I have something to report about Denis problem but had no time so far.

> As for your immediate problem, I'd counsel reducing that elog(STOP) to
> elog(DEBUG) so that you can bring the database up, and then you can
> try to pg_dump your current data.  You'll probably still want to
> re-initdb and restore once you get a consistent dump.
>
> Um, Vadim?  Still of the opinion that elog(STOP) is a good idea here?
> That's two people now for whom that decision has turned localized
> corruption into complete database failure.  I don't think it's a good
> tradeoff.

One is able to use pg_resetxlog so I don't see point in removing elog(STOP)
there. What do you think?

Vadim

pgsql-general by date:

Previous
From: Steven Vajdic
Date:
Subject: Postgres 7.1.3. installation on Windows platforms
Next
From: Stephan Szabo
Date:
Subject: Re: Referential Integrity Violation not triggered