README - HP Systems Insight Manager 5.3

.
-------------------------------------------------------------
If you want to upgrade from PostgreSQL 7.x (Rhel 3 or 4) to PostgreSQL 8.x (Rhel 5). When you upgrade
from 7.x to 8.x, the PostgreSQL service will fail to start because the internal data storage format changes
with new releases of PostgreSQL (8.x). Therefore, if you are upgrading an existing installation that does not
have a version number 8.1.x, you must back up and restore your data as shown here. Install the required
operating system (Rhel 3 or 4) and HP SIM (4.x or 5.0.x or 5.1) and then perform the following steps to
backup the database.
1. Login to the system from root user.
2. Stop the HP SIM service by running mxstop.
3. Verify that all the MX processes have stopped by running:
ps -ef | grep mx
4. MxDBUserPassword is internally set by HP SIM. This password is used to backup the database because
mxadmin is the owner of the insight_v1_0 db. Change the MxDBUserPassword to appropriate user
known password (In this case "test):
mxpassword -m -x MxDBUserPassword=test
5. Restart the PostgresSQL service to reflect the new MxDBUserPassword .
service postgresql restart or /etc/init.d/postgresql restart
6. Backup the database to a file using command pg_dump:
pg_dump -h 127.0.0.1 -p 5432 -U mxadmin insight_v1_0 > /home/SaveHPSIMdb
Provide the password supplied in step 4 (test in this example) for the backup.
SaveHPSIMdb = The file in which the old database is backed up. It is always safe to save this file in
/tmp or /home directory.
The database name, port number, host values can be obtained from the
/etc/opt/mx/config/database.props file.
7. Stop the PostgreSQL service:
service postgresql stop or /etc/init.d/postgresql stop
8. Move the old PostgreSQL files to mv /var/lib/pgsql/ /var/lib/pgsql.old
NOTE: The default postgres installation is /var/lib/pgsql and since the internal data storage
format changes with new releases. It is safe to move old data from the /var/lib/pgsql path and
have the fresh installation for PostgreSQL8.x.
9. Upgrade the operating from Rhel 3.x or 4.x to Rhel 5.x.
10. After the operating system is up, stop the HP SIM service and verify that the PostgreSQL service is up
and running (PostgreSQL service should be running to perform database restore).
11. Add the following entry in pg_hba.conf file which is available under
/var/lib/pgsql/data/pg_hba.conf (Comment out any existing entry in pg_hba.conf). Add the
below mentioned entries in pg_hba.conf file.
local insight_v1_0 mxadmin password local all all trust
host insight_v1_0 root 127.0.0.1 255.255.255.255 trust
host template1 postgres 127.0.0.1 255.255.255.255 trust
host postgres postgres 127.0.0.1 255.255.255.255 trust
host insight_v1_0 mxadmin 127.0.0.1 255.255.255.255 trust
12. Restart the PostgreSQL service:
service postgresql restart or /etc/init.d/postgresql restart
46 Known Issues and Workarounds