SUNScholar/Indexes/Purge

From Libopedia
Jump to navigation Jump to search
Back to Indexes

OLD BROWSE INDEX PURGE

Check that you have a backup of the SQL database before doing any purging. You have been warned.

For DSpace =>5.X

A new command has been introduced with DSpace =>5.X.

See below for an example.

$HOME/bin/dspace index-db-browse -f -d

See step 11 of: https://wiki.duraspace.org/display/DSDOC5x/Upgrading+DSpace

For DSpace <=4.X

Step 1 - Remove "communities2item" table

Login into the server as the dspace user and then type the following;

sudo -i
su - postgres
psql dspace
DELETE from communities2item;
\q
exit
exit
exit

Step 2 - Remove all "bi_" tables

I used pgadmin to do a "cascade drop" of all the bi_* tables, where bi = browse index.

Bug Reports