Re: Restore problem

From: "Trevor Talbot" <quension(at)gmail(dot)com>
To: "Keith Turner" <kturner(at)cloudsystems(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restore problem
Date: 2007-12-11 07:04:23
Message-ID: 90bce5730712102304s264184b3vd32b16e40a7bb784@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/10/07, Keith Turner <kturner(at)cloudsystems(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Talbot 2007-12-11 07:24:52 Re: SQL design pattern for a delta trigger?
Previous Message A. Kretschmer 2007-12-11 05:59:14 Re: Restore problem