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

Reply via email to