Re: Restore problem - Mailing list pgsql-general

From Trevor Talbot
Subject Re: Restore problem
Date
Msg-id 90bce5730712102304s264184b3vd32b16e40a7bb784@mail.gmail.com
Whole thread Raw
In response to Restore problem  ("Keith Turner" <kturner@cloudsystems.com>)
Responses Re: Restore problem
List pgsql-general
On 12/10/07, Keith Turner <kturner@cloudsystems.com> wrote:

> We are running 8.1 on Windows 2003 server and have had a server crash
> over the weekend. A virus is suspected - we maintain an app server on
> someone else's network, though we do have anti-virus running, the
> symptoms were worrying - so we had to wipe and reinstall the OS and all
> programs. We had recovered the 8.1 folder and the data off the crashed
> computer prior to the wipe, but the last good .backup file is a few days
> older than that.
>
> Are there step by step instructions on restoring from the folder itself
> instead of a backup file? Is it even possible?

I would try installing 8.1 again, stop the service, _copy_ your data
and config over the top of it, then start it again and see what
happens. Any problems with that should show up immediately in the
logs.

And if all else fails, you can just nuke the attempt and restore from
the older backups.

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Restore problem
Next
From: "Trevor Talbot"
Date:
Subject: Re: SQL design pattern for a delta trigger?