Re: Restoring database question.. - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Restoring database question..
Date
Msg-id 20060818195221.GA1502@wolff.to
Whole thread Raw
In response to Restoring database question..  (arsi@aranzo.netg.se)
Responses Re: Restoring database question..  (arsi@aranzo.netg.se)
List pgsql-admin
On Sat, Aug 12, 2006 at 19:58:52 +0200,
  arsi@aranzo.netg.se wrote:
>
> My question is as follows, is it possible to simply copy the data files
> to their correct location and getting access to the databases as they
> looked at the time of the hacking attempt?
> I should have the exact same setup before the hack as after, no version
> changes or anything.

If the database was running when the files were backed up, then just copying
them over is very unlikely to work.

> Or do I simply have to count my losses and restore from an old backup??

This is probably your best option.

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Inserting a timed delay in a pl/pgsql procedure
Next
From: John DeSoi
Date:
Subject: Re: Inserting a timed delay in a pl/pgsql procedure