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

From Tom Lane
Subject Re: Forgot to dump old data before re-installing machine
Date
Msg-id 14985.1200326336@sss.pgh.pa.us
Whole thread Raw
In response to Forgot to dump old data before re-installing machine  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
Responses Re: Forgot to dump old data before re-installing machine  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Re: Forgot to dump old data before re-installing machine  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ECPG problem with 8.3
Next
From: "henry"
Date:
Subject: Re: tcp_keepalives_idle ignored