Backing up or Restoring the Database on a HP-UX or Linux Operating System
A PostgreSQL server database is used in HP Systems Insight Manager to store all data relating to HP Systems Insight Manager. You should backup up your database regularly. If a restore is needed, the HP Systems Insight Manager CMS is restarted automatically during the restore process.
To backup and restore the database:
Enter /opt/mx/bin/mxrepositorysave –f file_name/directory to save the database.
If you passed a directory, the filename is generated with the date and time information. This feature works well for automatic backups.
You can also backup the file in gunzip format by providing the file name with the .gz string.
Enter /opt/mx/bin/mxrepositoryrestore –f filename to restore the database.
The CMS is restarted.
Note: All data in the current database is lost!
Schedule the backup.
Select ToolsCommand Line ToolsPostgreSQL DB BackupCMS node.
Note: If you want to schedule a backup to run regularly, you can specify a directory name for the parameters. The files are saved in gunzip format, with the date and time information in the file name. If you only want to run the backup one time, you can specify a directory or file name.
Change the HP Systems Insight Manager Database Password
During the HP Systems Insight Manager configuration, the mxadmin user is created in PostgreSQL, and the password is generated during configuration.
Enter /opt/mx/bin/mxpassword –l to retrieve the password MxDBUserPassword values.
Enter /opt/mx/bin/mxpassword –m –x MxDBUserPassword=newpassword to change the HP Systems Insight Manager database password.