SUNScholar/Daily Admin

Back to After Installation Tasks

Introduction

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

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

---

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)

---

References

• http://www.crontab-generator.org
• http://en.wikipedia.org/wiki/Cron
• http://adminschoice.com/crontab-quick-reference
• http://www.yourownlinux.com/2014/04/schedule-your-jobs-in-linux-with-cron-examples-and-tutorial.html
• http://ask.xmodulo.com/add-cron-job-linux.html
• http://teknixx.com/working-with-cron-jobs-on-linux