Difference between revisions of "SUNScholar/Daily Admin"

Revision as of 10:50, 6 February 2014

Back to After Installation Tasks

Click on the heading above.

Click on the heading above.

PostgreSQL also benefits from regular maintenance such as vacumn, which optimizes the indexes and clears out any deleted data.

Type as follows in a terminal:

sudo -i

Enter the "dspace" user password. Then type:

su - postgres

crontab -e

Copy and paste the following:

20 4 * * * vacuumdb --analyze dspace > /dev/null 2>&1

CTL+O	= Save the file and then press Enter
CTL+X	= Exit "nano"
CTL+K	= Delete line
CTL+U	= Undelete line
CTL+W	= Search for %%string%%
CTL+\	= Search for %%string%% and replace with $$string$$
CTL+C	= Show line numbers

@@ Line 11: / Line 11: @@
 ==PostgreSQL==
-PostgreSQL also benefits from regular 'vacuuming', which optimizes the indexes and clears out any deleted data.
+PostgreSQL also benefits from regular maintenance such as '''vacumn''', which optimizes the indexes and clears out any deleted data.
 Type as follows in a terminal: