Novell ZENWORKS LINUX MANAGEMENT 7.3 IR2, Administration Manual, Page: 88 / 684

88 Novell ZENworks 7.3 Linux Management Administration Guide
no
vd
ocx
(e
n)
7 Ja
nua
ry 201
0
9.2 Maintaining the ZENworks Data Store on
PostgreSQL
The following sections provide instructions for backing up and restoring the PostgreSQL Data
Store:
Š
Section 9.2.1, “Displaying the Password for the Default PostgreSQL Database,” on page 88
Š Section 9.2.2, “Understanding Automated Database Maintenance,” on page 88
Š
Section 9.2.3, “Backing Up the ZENworks Data Store,” on page 88
Š Section 9.2.4, “Restoring the ZENworks Data Store,” on page 89
Š
Section 9.2.5, “Optimizing the Server Database,” on page 90
Š Section 9.2.6, “Restarting Novell Zenworks Server Services After Restarting the Database,” on
page 92
9.2.1 Displaying the Password for the Default PostgreSQL
Database
The password for the default ZENworks PostgreSQL database is stored as plaintext on your
ZENworks Primary Server. You can access the database without the password if you are logged on
as Root.
If you need the password for maintenance purposes, you can use the following command to display
the password (you must be logged in as Root):
cat /etc/opt/novell/zenworks/serversecret
9.2.2 Understanding Automated Database Maintenance
If you are using a PostgreSQL database, there are some automated maintenance tasks that are
performed both daily and monthly.
Daily Maintenance: Once a day, old versions are flagged, allowing the space used by these records
to be used for new data; the statistics used by the query engine are updated to achieve the best
possible performance. This maintenance runs every day at 2:15 a.m.
Monthly Maintenance: Unlike the daily maintenance, the monthly maintenance actually frees the
space used by the old flagged records; this prevents a large disparity between the allocated disk
space for the database and the actual space used by the database. Because this is an intensive
process, 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 Store
This 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 is located in
/opt/novell/zenworks/sbin
.