Backing up and restoring HP SIM 5.2 or greater data files in an HP-UX and Linux environment

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. Restart the PostgreSQL service with the restart command (full command path might vary

depending on the PostgreSQL install location.

For HP-UX:

/sbin/init.d/hpsmdb restart

For SUSE Linux Enterprise Server 9 and SUSE Linux Enterprise Server 10:

/etc/init.d/hpsmdb restart

For Red Hat Enterprise Linux (all versions):

/etc/rc.d/init.d/hpsmdb restart

service hpsmdb restart

8. Enter the following commands to backup the database:

For HP-UX:

cd /opt/hpsmdb/pqsql/bin

For Linux:

cd /opt/hpsmdb/bin

./pg_dump –h 127.0.0.1 –U mxadmin –p 50006 insight_v1_0 >

/tmp/saveHPSIMdb

Where:

-h = host name of the server

-U = PostgreSQL user name

-p = port number (to find the port number, open the /etc/opt/mx/config/database.props

file and find the property value for the hp.Database.portNumber property.)

insight_v1_0 = HP SIM database name (To find the database name, open the

/etc/opt/mx/config/database.props file and find the property value for the

hp.Database.databaseName property.)

saveHPSIMdb = Any file name to save the database

9. When prompted for a password, enter the password defined in step 6.

Restoring data files for use with PostgreSQL

1. If performing a reinstallation of HP SIM, proceed as directed in the HP SIM 5.3 Installation Guide

located at:

For Linux:

http://docs.hp.com/en/418811-003/index.html

For HP-UX: