Vacuum Postgres nightly

- -

+Vacuum Postgres nightly

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,15 +14,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 - 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

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