Restoring data files for postgresql – HP Systems Insight Manager User Manual

Page 519

Restoring data files for PostgreSQL

To restore the database from a saved copy:

If performing a reinstallation of HP SIM, proceed as directed in the

If HP SIM is running, enter mxstop in the command line to stop the HP SIM daemons.

To verify that all HP SIM mx processes have stopped, run:

ps -ef | grep mx

For HP-UX, proceed with step 4.

For HP-UX:
a.

Uninstall the SysMgmtDB:

swremove -x enforce_dependencies=false SysMgmtDB

Install Sys Managhement DB from HP SIM's Depot file:

swinstall -s /hpsim.depot SysMgmtDB

For Linux:
a.

To edit the pg_hba.conf file, enter:

vi /var/lib/pgsql/data/pg_hba.conf

and add:

local insight_v1_0 mxadmin password

local all all trust

host insight_v1_0 root 127.0.0.1 255.255.255.255 trust

Stop the postgreSQL service:

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

Shift the user : Login as postgres:

su postgres

To delete the dabase, enter:

cd /usr/bin

and then run:

dropdb -p 5432 –h 127.0.0.1 –i –e insight_v1_0

Create a database with the name insight_v1_0:

For HP-UX:

cd /opt/hpsmdb/pgsql/bin

./createdb -O hpsmdb -h 127.0.0.1 -p 50006 -U hpsmdb insight_v1_0

For Linux:

cd /usr/bin

./createdb –O postgres –h 127.0.0.1 –p 5432 –U postgres insight v1 0

Backing up and restoring the database 519