I assume you’re asking this because you don’t have a backup of the database, so
I won’t suggest using that to restore.. :)
First of all, make sure you DON’T run postgres’ vacuum on the database, second,
make a copy of the pgdata folder just in case. I believe that deleted database
items are not physically erased from postgres’ internal data storage (typically
the pgdata folder) until you do a vacuum. Some eight years ago I accidentally
deleted a large amount of data from a postgres database but was able to recover
it somehow, but I just can’t remember how. Try a google search..
I believe you can’t recreate the database contents from the assetstore, as the
assetstore only contains bitstreams and not metadata.
good luck,
Mathias Hjelt
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ROHAZNA BINTI
WAHAB
Sent: 28. helmikuuta 2008 10:33
To: [email protected]
Subject: [Dspace-tech] Accidently drop table in postgres
Hi ..
Can someone help me?.. I accidently drop / deleted dspace databased .. I need
an advised on:
1. Is there any way to recover the data?
2. I still have physical files in assetstore folder. How to use that file back?
i'm using dspace version 1.4.2. Tq in advanced
Regards,
Rohazna Wahab
Pegawai Teknologi Maklumat
Pusat Teknologi Maklumat & Komunikasi
Universiti Malaysia Perlis
Tel : 049798280
Fax : 049798227
--
This message has been scanned for viruses and
dangerous content by MailScanner <http://www.unimap.edu.my/> , and is
believed to be clean.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech