User Guide

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 the directory to c:\Program Files\PostgreSQL\8.4.2\bin.
3. Issue the command DROPDB –U postgres AMPDB.
4. If prompted, enter your postgres user password.
5. The response is a dropdb -U postgres AMPDB.
To create the blank database for the restore:
1. Type CREATEDB –O postgres –U postgres "AMPDB" TEMPLATE="AMPDB", press Enter.
2. Type psql –U postgres –d AMPDB –f C:\AMPDB-Backup.sql, press Enter.
3. Start the Avocent Management Platform ESB Service.
To restore the database on a Linux server:
1. Stop the Avocent Management Platform ESB service.
2. At the terminal or command line of your Linux server, type service smx stop.
3. The prompt will return, Stopping ServiceMix Application Server…
4. You will see, Stopped ServiceMix Application Server.
To drop the AMPDB database:
NOTE: The restore will not work if there is any existing data in the AMPDB tables.
1. Open a command prompt or terminal window, and issue the command dropdb –U postgres AMPDB.
2. If prompted, enter your postgres user password.
3. The response is a dropdb -U postgres AMPDB.
To create the blank database for the restore:
1. Type CREATEDB –O postgres –U postgres "AMPDB" TEMPLATE="AMPDB" and press Enter.
2. Type psql –U postgres –d AMPDB –f C:\AMPDB-Backup.sql.
3. Start the Avocent Management Platform Service.
Microsoft® SQL Server Backup
For instructions on backing up an SQL Server, refer to "How to Back up a Database (SQL Server)" on the
Microsoft web site.
Connect to an Existing Microsoft Server Database
This process allows you to connect to a database that already exists on your system.
Chapter 8: Database Information 41