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 -r1.15 --- openacs-4/packages/acs-core-docs/www/database-management.html 11 Nov 2003 12:54:57 -0000 1.14 +++ openacs-4/packages/acs-core-docs/www/database-management.html 19 Nov 2003 15:44:49 -0000 1.15 @@ -1,8 +1,7 @@ -Database Management

Database Management

- by Joel Aufrecht
+Database Management

Database Management

By Joel Aufrecht

OpenACS docs are written by the named authors, and may be edited by OpenACS documentation staff. -

Running a PostGreSQL database on another server

To run a database on a different machine than the +

Running a PostGreSQL database on another server

To run a database on a different machine than the webserver requires changes to the database configuration file and access control file, and to the OpenACS service's configuration file.

  • Edit the database configuration file, which in a @@ -37,7 +36,7 @@ your server in /etc/inittab, reread the inittab with /sbin/init q, and then restart-aolserver - service0.

    Then, to drop the db, just do:

    +        service0.

    Then, to drop the db, just do:

     service0:~$ dropdb service0
     DROP DATABASE

Vacuum Postgres nightly

The "vacuum" command must be run periodically to reclaim space. The @@ -55,4 +54,4 @@

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 birdnotes
($Id$)
View comments on this page at openacs.org
+0 1 * * * /usr/local/pgsql/bin/vacuumdb birdnotes
($Id$)
View comments on this page at openacs.org