Re: Recovering a broken database - Mailing list pgsql-general

From Tom Lane
Subject Re: Recovering a broken database
Date
Msg-id 17940.1120137073@sss.pgh.pa.us
Whole thread Raw
In response to Re: Recovering a broken database  (Ciprian Popovici <ciprian@zuavra.net>)
Responses Re: Recovering a broken database
List pgsql-general
Ciprian Popovici <ciprian@zuavra.net> writes:
> Come to think of it better, at some point I might've switched
> repositories with 8.0 still running.

Hmm, you mean you renamed the 8.0 directory tree out of the way
and then moved the 7.4 tree where it had been, without stopping
the 8.0 postmaster?  Oh dear.

You've more than likely got a database that has had parts of some
files overwritten with data from the 8.0 installation.  I don't
think there's much chance of getting out of that mess, and certainly
not with any trust in the consistency of your data.  Hope you had a
backup...

But congratulations on finding an entirely new way around the
safety interlocks that are intended to prevent this sort of
disaster.  We shall have to think about whether we can fix that.

            regards, tom lane

pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Possible move away from PG
Next
From: Charles Swiger
Date:
Subject: Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users