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

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: Forgot to dump old data before re-installing machine
Дата
Msg-id 65937bea0801141257u5aabe4fbj5853526446392c37@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Forgot to dump old data before re-installing machine  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
And also remember to use the same version of Postgres as the previous installation...

It might be helpful to post the tail of your server's log ahen it fails.

Best Regards,

On Jan 14, 2008 7:58 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Stefan Schwarzer <stefan.schwarzer@grid.unep.ch> writes:
> 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?

                       regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings



--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

17° 29' 34.37"N,   78° 30' 59.76"E - Hyderabad
18° 32' 57.25"N,   73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco *

http://gurjeet.frihost.net

Mail sent from my BlackLaptop device

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

Предыдущее
От: Adam Rich
Дата:
Сообщение: Locking & concurrency - best practices
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Locking & concurrency - best practices