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.21.2.1 -r1.21.2.2 --- openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html 12 Jun 2011 20:03:48 -0000 1.21.2.1 +++ openacs-4/packages/acs-core-docs/www/install-next-nightly-vacuum.html 12 Jun 2011 20:52:57 -0000 1.21.2.2 @@ -1,5 +1,5 @@ -Vacuum Postgres nightly
Alex logo
Prev Chapter 6. Database Management Next

Vacuum Postgres nightly

+Vacuum Postgres nightly

Alex logo
Prev Chapter 6. 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 Appendix A. Install Red Hat 8/9
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 7. Backup and Recovery
docs@openacs.org
View comments on this page at openacs.org