HP Systems Insight Manager - Manual (Page 518)

(optional) Contains job result output /var/opt/mx/output
Note: The file permissions must be preserved during the backup process. The Tape Archive (TAR) utility
preservers file permissions.
4. Save any existing user-supplied (custom) files contained in the HP SIM directory tree, such as tool
definition files (TDEFs), Management Information Bases (MIBs), sign in prompt, and actions.
5. Open /etc/opt/mx/config/database.props file and check the property value for
hp.database.username
. The default PostgreSQL user for HP SIM is mxadmin.
6. The password generated by HP SIM for mxadmin must be changed before backing up the database.
To change the password, at the HP SIM command line enter the following:
/opt/mx/bin/mxpassword -m -x MxDBUserPassword=newpassword
where newpassword is the new password.
7. Stop the PostgreSQL service with the stop command (full command path might vary depending on the
PostgreSQL install location):
For HP-UX
/sbin/init.d/hpsmdb stop
For SUSE Linux Enterprise Server 9 and SUSE Linux Enterprise Server 10
/etc/init.d/postgresql stop
For Red Hat Enterprise Linux (all versions)
/etc/rc.d/init.d/postgresql stop
8. Restart the PostgreSQL service with the start> command (full command path might vary depending
on the PostgreSQL install location
Note: It can take up to several minutes for PostgreSQL to start. To check the status of Linux, enter the
postgresql status
command.
For SUSE Linux Enterprise Server 9 and SUSE Linux Enterprise Server 10
/etc/init.d/postgresql start
For Red Hat Enterprise Linux (all versions)
/etc/rc.d/init.d/postgresql start
It may take up to several minutes for PostgreSQL to start. To check the status in Linux, enter the postgresql
status command:
For SUSE Linux Enterprise Server 9 and SUSE Linux Enterprise Server 10
/etc/init.d/postgresql status
For Red Hat Enterprise Linux (all versions)
/etc/rc.d/init.d/postgresql status
9. Enter the following commands:
For HP-UX
cd /opt/hpsmdb/pqsql/bin
./pg_dump –h 127.0.0.1 –U mxadmin –p 50006 insight_v1_0 > saveHPSIMdb
For Linux
cd /user/bin
pg_dump –h 127.0.0.1 –U mxadmin –p 5432 insight_v1_0 > saveHPSIMdb
where -p is the port number. To find the port number, open /etc/opt/mx/config/database.props
and look for the property value of hp.database.portnumber.
and saveHPSIMdb is the file name of the saved database.
10. When prompted for a password, enter enter the password defined in step 6.
518 Administering systems and events