Dspace- Backup and Restore

I. Backup
Apply following commands,

sudo su - postgres
pg_dump dspace > dspace.backup

 
The backup will create in /var/lib/postgresql/ 

 

Create backup of asseststore and log

sudo zip -r assetstore.zip /dspace/assetstore
sudo zip -r log.zip /dspace/log

It is advisable to copy the following folders also to dspace folder to restore as previous

1. Solr 2. upload 3. webapps 4. config 5.bin

 

 
II. Restoration

 
Copy the assetstore, log folders, and database backup to home folder.

Extract the assetstore and log folders. 

 

Stop Tomcat server
sudo service tomcat stop
 

Remove assetstore and log folders from the newly installed dspace

sudo rm -rf /dspace/assetstore
sudo rm -rf /dspace/log/

 
Move  old assetstore and log folders to /dspace folder.

sudo mv assetstore /dspace
sudo mv log /dspace
 

Restoration of database

Restart PostgreSQL
sudo systemctl stop postgresql
sudo systemctl start postgresql 

Delete the existing dspace database and create a new one. Commands for this
sudo -u postgres psql
DROP DATABASE dspace;
CREATE DATABASE dspace;
\quit
 

Restore dspace backup from the home folder

sudo su postgres
psql -f dspace.backup dspace

 

Install pgcrypto postgres extension

psql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;"
exit

 

Execute the following commands one by one,

sudo /dspace/bin/dspace database info

sudo /dspace/bin/dspace database migrate

sudo /dspace/bin/dspace index-discovery -b

 sudo /dspace/bin/dspace filter-media

 sudo /dspace/bin/dspace index-discovery

 sudo /dspace/bin/dspace index-discovery -o

 

Restart Tomcat
sudo service tomcat start