Re: Forgot to dump old data before re-installing machine

Поиск
Список
Период
Сортировка
От Stefan Schwarzer
Тема Re: Forgot to dump old data before re-installing machine
Дата
Msg-id 95A9F316-7E21-4E9F-97CD-D5FD5051B08C@grid.unep.ch
обсуждение исходный текст
Ответ на Re: Forgot to dump old data before re-installing machine  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Forgot to dump old data before re-installing machine  (Richard Huxton <dev@archonet.com>)
Re: Forgot to dump old data before re-installing machine  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
>> I re-installed my machine and "forgot" to dump my database(s). I
>> naturally still have the whole database folders. For the moment I
>> installed the "old" postgres version (8.1) to be able to read my
>> data.
>> But how can I read them? It seems that it doesn't work that I just
>> overwrite the new database folder with the old one... Would be too
>> simple, I guess...
>
> Should work, if you've got the whole $PGDATA directory tree.  Maybe
> you forgot to stop the postmaster while copying the backup into place?

Thanks a lot for this. Still trying. But although the postmaster did
run at one time, now, after copying back and forth, it doesn't want to
do anything anymore... Gush, getting really frustrated...

Stef


В списке pgsql-general по дате отправления:

Предыдущее
От: Stefan Schwarzer
Дата:
Сообщение: Postgres installation on Leopard; database on Mac-User-Level
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: count(*) and bad design was: Experiences with extensibility