User Guide

• Database Name - Create a name.
• 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.
19. Click Install. The installation begins. Upon completion, the Install Complete screen opens.
20. Click Done to complete the installation. See Installation on page 11.
To connect to an existing PostgreSQL database using a Linux server:
1. On the Database Selection screen during the installation, select the Connect to existing PostgreSQL
database radio button and click Next. The Existing PostgreSQL Database Configuration screen opens. A
new database will be created at the location of the existing database.
2. From a terminal window, enter createdb <database name> -U<postgres user>. A message displays
stating create database.
3. Enter psql -d<database name> -U<postgres user>.
4. At the prompt <database name>=# enter Alter <database name> set Encoding = 'UTF8'.
5. At the next prompt, enter \q. This takes you out of the Postgres application.
6. Go to the Postgres data directory where Postgres was installed, var/lib/pgsql/data for Postgres version 8.2, or
for a new installation, the directory is opt/PostgreSQL/8.4.2/data.
7. Enter vi pg-hba.conf.
8. Click the Insert key.
9. Scroll to the bottom and locate #IPv4 local connections:
10. Go to the line host all all (IPlocalhost address) trust and click Enter.
11. On the blank line, enter: host all all 0.0.0.0/0 trust
12. Press the Esc key, hold down the Shift key and click the : key.
13. Enter wq and click Enter.
14. Enter vi postgresql.conf
15. Under connections and authentication, delete the # in front of listen_addresses and change localhost to an
asterisk (*).
16. Click the Esc key, hold down the Shift key and click the : key.
17. Enter wq and click Enter.
18. Click System - Administration - Services.
19. Highlight posgresql and click Restart.
20. Exit from the Services Configuration by either clicking the (x) in the upper, right corner or File, Quit.
21. Close the system where the new database was created.
22. Go back to the installation process at the Existing PostgreSQL Database Configuration screen and enter the
new database information.
• Database Server - (Port number 5432, default) - The system where the new database was created.
• Database Name - Create a name.
36 Data Center Planner Installer/User Guide