User Guide

To create the blank database for the restore:
1. Type: CREATEDB "AMPDB" –O postgres –U postgres TEMPLATE="AMPDB"
2. Type:psql -U postgres -d AMPDB -f AMPDB-Backup.sql
3. Start services with service smx start.
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. If successful, the prompt will return 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.
2. Issue the following command: dropdb AMPDB –U postgres.
3. If prompted, enter your postgres user password.
4. The response is a DROP DATABASE.
To create the blank database for the restore:
1. Type: createdb "AMPDB" –O postgres –U postgres TEMPLATE="AMPDB"
2. Type: psql -U postgres -d AMPDB -f AMPDB-Backup.sql
3. Start Avocent Management Platform Service.
PostgreSQL 8.4.2 Database Backup
The following information describes the process for backing up and restoring the PostgreSQL database, version
8.4.2.
Backing up the PostgreSQL database with pg_dump
The idea behind the SQL-dump method is to generate a text file with SQL commands that, when fed back to the
server, will recreate the database in the same state as it was at the time of the dump.
To backup the database on a Windows server:
1. Stop the Avocent Management Platform ESB service by using one of the following methods.
2. Using a Windows server:
a. Go to Start - Control Panel - Administrative Tools - Services.
b. Locate the service Avocent Management Platform ESB, right-click and select Stop.
3. Using the command prompt:
Chapter 8: Database Information 39