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 @@ -14,6 +16,15 @@ 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$)

+ +