86 Novell ZENworks 7.2 Linux Management Administration Guidenovdocx (en) 11 July 2008 Section 9.2.5, “Optimizing the Server Database,” on page 88 Section 9.2.6, “Restarting Novell Zenworks Server Services After Restarting the Database,” onpage 899.2.1 Displaying the Password for the Default PostgreSQLDatabaseThe password for the default ZENworks PostgreSQL database is stored as plaintext on yourZENworks Primary Server. You can access the database without the password if you are logged onas Root.If you need the password for maintenance purposes, you can use the following command to displaythe password (you must be logged in as Root):cat /etc/opt/novell/zenworks/serversecret9.2.2 Understanding Automated Database MaintenanceIf you are using a PostgreSQL database, there are some automated maintenance tasks that areperformed both daily and monthly.Daily Maintenance: Once a day, old versions are flagged, allowing the space used by these recordsto be used for new data; the statistics used by the query engine are updated to achieve the bestpossible performance. This maintenance runs every day at 2:15 a.m.Monthly Maintenance: Unlike the daily maintenance, the monthly maintenance actually frees thespace used by the old flagged records; this prevents a large disparity between the allocated diskspace for the database and the actual space used by the database. Because this is an intensiveprocess, it is scheduled monthly instead of daily. It runs at 3:15 a.m on the first day of each month.9.2.3 Backing Up the ZENworks Data StoreThis section applies only if you are using the PostgreSQL database for your Data Store.You can use zlm_dbbackup.sh to make a backup of the Data Store. This backup utility islocated in /opt/novell/zenworks/sbin.1 Make sure you are logged in as root to a ZENworks Server.2 On the ZENworks Primary Server with the local data store, enter the following at the commandprompt:zlm_dbbackup.shNOTE: Database backup operation is supported from the Secondary servers only if its PostgreSQLdatabase version is same as the Primary server. For example, you cannot run the backup utility froma SLES 9 secondary server if the primary server is a SLES 10 server. This is because the SLES 9server's pg_dump utility, which is used by the backup utility, is incompatible with the PostgreSQLdatabase version running on the primary server. You have to run the backup utility on the primaryserver.
