Difference between revisions of "SUNScholar/Indexes/Purge"

Latest revision as of 09:46, 5 August 2016

Back to Indexes

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

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

See below for an example.

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

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

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

@@ Line 2: / Line 2: @@
   '''[[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__