Database Management

- by Joel Aufrecht
+Database Management

Prev	Chapter�6.�Maintenance	Next

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$)

Prev	Home	Next
Hosting Web Sites	Up	Backup and Recovery

docs@openacs.org

View comments on this page at openacs.org +0 1 * * * /usr/local/pgsql/bin/vacuumdb birdnotes

($Id$)