The "vacuum" command must be run periodically to reclaim space in versions of PostgreSQL before 7.4. The @@ -22,18 +22,17 @@ before!) you've made a backup! The "vacuum" command is very reliable, but conservatism is 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
+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: database-maintenance.xml,v 1.9 2017/08/07 23:47:54 gustafn Exp $)