| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Forgot to dump old data before re-installing machine |
| Date: | 2008-01-14 15:58:56 |
| Message-ID: | 14985.1200326336@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Harrison | 2008-01-14 16:42:50 | Re: Online Oracle to Postgresql data migration |
| Previous Message | Tom Lane | 2008-01-14 15:57:45 | Re: ECPG problem with 8.3 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gurjeet Singh | 2008-01-14 20:57:18 | Re: Forgot to dump old data before re-installing machine |
| Previous Message | Stefan Schwarzer | 2008-01-14 13:06:15 | Forgot to dump old data before re-installing machine |