Re: Recovering a broken database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Recovering a broken database
Дата
Msg-id 17940.1120137073@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Recovering a broken database  (Ciprian Popovici <ciprian@zuavra.net>)
Ответы Re: Recovering a broken database  (Ciprian Popovici <ciprian@zuavra.net>)
Список 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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Possible move away from PG
Следующее
От: Charles Swiger
Дата:
Сообщение: Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users