beautypg.com

Backup and restore utilities location, Command to back up data, Command to restore data – HP P6000 Performance Advisor Software User Manual

Page 138

background image

Backup and restore utilities location

The backup and restore command line utilities are available in the following folder, if you installed
HP P6000 Performance Advisor in the default folder:

C:\Program Files\Hewlett-Packard\EVAPA\DataBase\Postgres\tools\

if HP

P6000 Performance Advisor is installed on a Windows 32-bit server

c:\Program Files(x86)\Hewlett-Packard\EVAPA\DataBase\Postgres\tools\
if HP P6000 Performance Advisor is installed on a Windows 64-bit server

IMPORTANT:

The HP P6000 Performance Advisor Database service must be running for both backup and
restore command line utilities to function.

If you installed HP P6000 Performance Advisor in a custom location, ensure that the user who
is performing the data backup or restore has write permission to the custom install location.

If you plan to remove HP P6000 Performance Advisor on the source server, ensure that your
backup folder is copied to a location other than the default install location.

Command to back up data

Enter the following command in your command prompt window:

dbCreateBackupDump [POSTGREBIN] [DBPORT] [BACKUP_FILE]

If POSTGREBIN is empty, the environment variable EVAPA_POSTGREBIN is used. If
EVAPA_POSTGREBIN

is not set, C:\PROGRA~1\POSTGR~1\9.0\bin is used.

If DBPORT is empty, the environment variable EVAPA_DB_PORT is used. If EVAPA_DB_PORT
is not set, port 2377 is used by default.

Sample backup command output follows:

The format of the backup file name is p6000pa-2011-06-15-0403PM.backup. The backup
output file is copied to the .\backup subfolder location. The backup log files are available
in the .\logs sub folder.

Command to restore data

WARNING!

Before restoring data, ensure that the HP P6000 Performance Advisor instance on

the target server is installed the first time or reinstalled,and current data is not retained. If data
already exists on the target server, the restore operation might fail.

To restore the backed-up data:
1.

Stop the HP P6000 Performance Advisor Server service.

138

Maintaining database

This manual is related to the following products: