Index: openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html,v diff -u -r1.23 -r1.24 --- openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html 27 Oct 2014 16:39:20 -0000 1.23 +++ openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html 7 Aug 2017 23:47:50 -0000 1.24 @@ -1,5 +1,5 @@ -Vacuum Postgres nightly
Alex logo
Prev Chapter 7. Database Management Next

Vacuum Postgres nightly

+Vacuum Postgres nightly

Alex logo
Prev Chapter 7. Database Management Next

Vacuum Postgres nightly

The "vacuum" command must be run periodically to reclaim space in versions of PostgreSQL before 7.4. The "vacuum analyze" form additionally collects statistics on the @@ -16,4 +16,4 @@ 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$)
Prev Home Next
Deleting a tablespace Up Chapter 8. Backup and Recovery
docs@openacs.org
View comments on this page at openacs.org
+0 1 * * * /usr/local/pgsql/bin/vacuumdb $OPENACS_SERVICE_NAME
($Id$)
Prev Home Next
Deleting a tablespace Up Chapter 8. Backup and Recovery
docs@openacs.org