Index: openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.adp,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.adp 8 Nov 2017 09:42:11 -0000 1.3 +++ openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.adp 25 Apr 2018 08:38:27 -0000 1.4 @@ -3,11 +3,11 @@ Vacuum Postgres nightly -
+ leftLink="install-openacs-delete-tablespace" leftLabel="Prev" + title="Chapter 7. Database +Management" + rightLink="backup-recovery" rightLabel="Next"> +

Vacuum Postgres nightly

The "vacuum" command must be run periodically to reclaim space in versions of PostgreSQL before 7.4. The @@ -22,18 +22,17 @@ before!) you've made a backup! The "vacuum" command is very reliable, but conservatism is the key to good system management. So, if you're using the export procedure described -above, you don't need to do this extra step.

Edit your crontab:

-[joeuser ~]$ crontab -e
+above, you don't need to do this extra step.

Edit your crontab:

[joeuser ~]$ crontab -e
 

We'll set vacuum up to run nightly at 1 AM. Add the following line:

 0 1 * * * /usr/local/pgsql/bin/vacuumdb $OPENACS_SERVICE_NAME
 

($‌Id: database-maintenance.xml,v 1.9 2017/08/07 23:47:54 gustafn Exp $)

- \ No newline at end of file + leftLink="install-openacs-delete-tablespace" leftLabel="Prev" leftTitle="Deleting a tablespace" + rightLink="backup-recovery" rightLabel="Next" rightTitle="Chapter 8. Backup and +Recovery" + homeLink="index" homeLabel="Home" + upLink="database-management" upLabel="Up"> + \ No newline at end of file