Restoring database question.. - Mailing list pgsql-admin

From arsi@aranzo.netg.se
Subject Restoring database question..
Date
Msg-id Pine.LNX.4.62.0608121958150.948@aranzo.netg.se
Whole thread Raw
Responses Restoring database question, part 2..
Re: Restoring database question..
List pgsql-admin
Hi all,

I have a problem. My server got hacked and someone did an rm -rf * on the
/home and /var folders. The backups to my database were not as fresh as
they should be but I have been able to recover all the files that existed
before the rm from the old harddrive, including the files located in the
data folder for postgres.

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.

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

I have a Debian Linux (stable) and the Postgres version is 7.4.

Thanks in advance,
Archie



pgsql-admin by date:

Previous
From: RPK
Date:
Subject: Migration tool
Next
From: "j n"
Date:
Subject: localization problem