Index: openacs-4/packages/acs-core-docs/www/database-management.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/database-management.html,v diff -u -r1.14.2.3 -r1.14.2.4 --- openacs-4/packages/acs-core-docs/www/database-management.html 8 Dec 2003 15:41:16 -0000 1.14.2.3 +++ openacs-4/packages/acs-core-docs/www/database-management.html 15 Dec 2003 15:03:46 -0000 1.14.2.4 @@ -37,7 +37,7 @@ reread the inittab with /sbin/init q, and then restart-aolserver service0.

Then, to drop the db, just do:

-service0:~$ dropdb service0
+[service0 ~]$ dropdb service0
 DROP DATABASE

Vacuum Postgres nightly

The "vacuum" command must be run periodically to reclaim space. The "vacuum analyze" form additionally collects statistics on the @@ -52,6 +52,6 @@ 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

We'll set vacuum up to run nightly at 1 AM. Add the following +[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 birdnotes
($Id$)
View comments on this page at openacs.org