User Guide

• User Name - Enter postgres.
• Password - Enter the password created when AMP was first installed and click Next. The Pre-Installation
Summary screen opens. On a Linux machine, this screen will appear different.
23. Click Install. The installation begins. Upon completion, the Install Complete screen opens.
24. Click Done to complete the installation.
25. Continue as instructed in the Installation section.
PostgreSQL 8.2 Database Backup
The following information describes the process for backing up and restoring the PostgreSQL database, version
8.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 steps:
2. Using the Windows server:
a. Go to Start, Control Panel, Administrative Tools, Services.
b. Locate the service named Avocent Management Platform ESB, right-click and select Stop.
3. Using the command prompt:
a. Click Start, Run. At the command prompt, enter: net stop "Avocent Management Platform ESB".
b. You should see the following: The Avocent Management Platform ESB service is stopping…
c. If successful, you should see the following: The Avocent Management Platform ESB service was
stopped successfully.
To issue pg_dump to backup the Avocent Management Platform database:
1. Click Start, Run to open a command prompt window.
2. At the command prompt, change directory to c:\Program Files\PostgreSQL\8.2\bin.
3. Issue the following command: pg_dump –U postgres AMPDB > C:\AMPDB-Backup.sql (the syntax
structure is = pg_dump -U <username> <DBname> <filename>)
4. If prompted, enter your DBAdmin password.
5. Upon completion of the backup process, you may copy the AMPDB-Backup.sql file to another location if
needed. This may take a moment.
6. Restart the Avocent Management Platform ESB Services.
7. Enter: net start "Avocent Management Platform ESB"
8. The response is: The Avocent Management Platform ESB service is starting…
9. If successful, the response is: The Avocent Management Platform ESB service was started successfully.
Chapter 8: Database Information 37