Cleaning the Database

When an entry is removed in a Postgres database, the database marks the entry as invalid, but does not remove the entry from the database. There is a tool, /opt/novell/zenworks/bin/zlm-pq-vacuum, that can be run to purge the database of all removed items.

Run this tool periodically, or as a cron job to keep your database clean.

You should note that you may need to edit the zlm-pq-vacuum file to allow for silent execution of the tool. By following the instructions in the file you can have the tool bypass the prompt for the database password.

Novell ZENworks 7 Linux Management Administrator's Handbook
Novell ZENworks 7 Linux Management Administrators Handbook
ISBN: 0672327848
EAN: 2147483647
Year: 2005
Pages: 147 © 2008-2017.
If you may any questions please contact us: