Skip site navigation (1) Skip section navigation (2)

Re: Restoring database question..

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: arsi(at)aranzo(dot)netg(dot)se
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restoring database question..
Date: 2006-08-18 19:52:21
Message-ID: 20060818195221.GA1502@wolff.to (view raw or flat)
Thread:
Lists: pgsql-admin
On Sat, Aug 12, 2006 at 19:58:52 +0200,
  arsi(at)aranzo(dot)netg(dot)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.

In response to

Responses

pgsql-admin by date

Next:From: Michael FuhrDate: 2006-08-18 20:28:54
Subject: Re: Inserting a timed delay in a pl/pgsql procedure
Previous:From: John DeSoiDate: 2006-08-18 19:50:02
Subject: Re: Inserting a timed delay in a pl/pgsql procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group