| From: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Forgot to dump old data before re-installing machine |
| Date: | 2008-01-15 13:42:05 |
| Message-ID: | 95A9F316-7E21-4E9F-97CD-D5FD5051B08C@grid.unep.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
>> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | T.J. Adami | 2008-01-15 13:43:09 | Re: backup and restore |
| Previous Message | Stefan Schwarzer | 2008-01-15 13:40:50 | Postgres installation on Leopard; database on Mac-User-Level |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aidan Van Dyk | 2008-01-15 13:54:46 | Re: SSL over Unix-domain sockets |
| Previous Message | Alvaro Herrera | 2008-01-15 12:21:21 | Re: SSL over Unix-domain sockets |