User Guide

To backup the database on a Linux server:
1. Stop the Avocent Management Platform ESB service by using one of the following steps:
2. At the terminal or command line of your Linux server, enter: service smx stop.
3. The prompt will return, Stopping ServiceMix Application Server…
4. If successful, the prompt will return, Stopped ServiceMix Application Server.
To issue pg_dump to backup the Avocent Management Platform database:
1. At the command prompt window, issue the following command: pg_dump –U postgres AMPDB >
AMPDB-Backup.sql (the syntax structure is = pg_dump –U <username> <DBname> <filename>).
2. If prompted, enter your DBAdmin password.
3. Upon completion of the backup process, copy the AMPDB-Backup.sql file to another location if needed.
This may take a moment.
4. Restart the Avocent Management Platform ESB services.
5. Enter: service smx start.
6. The response is: Starting ServiceMix Application Server…
7. If successful, you will be returned to the command prompt.
Restore the Database with psql
To restore the database on a Windows server:
1. Stop the Avocent Management Platform ESB service by using one of these methods.
2. Using the Windows interface, click Control Panel, Administrative Tools, Services.
a. Locate the service named Avocent Management Platform ESB.
b. Right-click and select Stop.
3. Using the command prompt, click Start, Run.
a. Enter: net stop "Avocent Management Platform ESB"
b. The response is, The Avocent Management Platform ESB service is stopping…
c. If successful, the response is, The Avocent Management Platform ESB service was stopped successfully.
To drop the AMPDB database:
NOTE: The restore will not work if there is any existing data in the AMPDB tables.
1. Using command prompt, click Start, Run.
2. Change directory to c:\Program Files\PostgreSQL\8.2\bin.
3. Issue the following command: DROPDB AMPDB –U postgres
4. If prompted, enter your postgres user password.
5. The response is a DROP DATABASE.
38 Data Center Planner Installer/User Guide