In order to send out subscription emails, update search and browse indexes and do general daily housekeeping on the system, a regular maintenance script must be run automatically daily.
On a Unix/Linux based system this is easy to accomplish with use of the "crontab" facility.
Click on the headings below for more details of required "crontab"'s.
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:
Enter the "dspace" user password. Then type:
su - postgres
Copy and paste the following:
20 4 * * * vacuumdb --analyze dspace > /dev/null 2>&1
- NANO Editor Help
|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|
More info = http://en.wikipedia.org/wiki/Nano_(text_editor)