Search Postgresql Archives

Re: Recovering a broken database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ciprian Popovici <ciprian@xxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux