Re: Restoring databases from a different installment on Windows - Mailing list pgsql-general

From Berislav Lopac
Subject Re: Restoring databases from a different installment on Windows
Date
Msg-id 1149060362.063814.173980@u72g2000cwu.googlegroups.com
Whole thread Raw
In response to Restoring databases from a different installment on Windows  ("Berislav Lopac" <berislav.lopac@gmail.com>)
Responses Re: Restoring databases from a different installment on Windows
List pgsql-general
Bruno Wolff III wrote:
> Yes it should work. There should be a recovery if postgres was running when
> the boc crashed.
> Note, you don't want to copy files out from under a running server to do
> backups. That won't work.

Actually, my situation is like this:

I had a properly running version of Postgres when my Windows crashed. I
Installed a fresh copy on Windows on another disk, and then Postgres on
top of it. Then I started the system from the new Windows, stopped the
Postgres service and copied the data directory from the old system to
the new one, but Postgres service refused to start.

So it was not some kind of a backup copy, it was a regular directory of
another installation.

Any ideas?

Thanks,

Berislav


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: strange stable function behavior
Next
From: dananrg@yahoo.com
Date:
Subject: Re: Best open source tool for database design / ERDs?