Re: Forgot to dump old data before re-installing machine - Mailing list pgsql-general

From Stefan Schwarzer
Subject Re: Forgot to dump old data before re-installing machine
Date
Msg-id 95A9F316-7E21-4E9F-97CD-D5FD5051B08C@grid.unep.ch
Whole thread Raw
In response to Re: Forgot to dump old data before re-installing machine  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses 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>)
List 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 by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Postgres installation on Leopard; database on Mac-User-Level
Next
From: Alban Hertroys
Date:
Subject: Re: count(*) and bad design was: Experiences with extensibility