View source for SUNScholar/Indexes/Purge

<center>
 '''[[SUNScholar/Indexes|Back to Indexes]]'''
</center>
==<font color="red">'''OLD BROWSE INDEX PURGE'''</font>==
<font color="red">'''Check that you have a backup of the SQL database before doing any purging. You have been warned.'''</font>
===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 [http://www.pgadmin.org pgadmin] to do a "cascade drop" of all the bi_* tables, where bi = browse index.

===Bug Reports===
*https://jira.duraspace.org/browse/DS-2602
*https://jira.duraspace.org/browse/DS-2578
*https://jira.duraspace.org/browse/DS-2188
*https://jira.duraspace.org/browse/DS-2145
*https://jira.duraspace.org/browse/DS-1920
*https://jira.duraspace.org/browse/DS-1619

[[Category:Customisation]]
__NOTOC__