User Guide

Database Information
8
35
Connecting to an Existing PostgreSQL Database
This option allows you to connect to a PostgreSQL database that already exists on your system.
To connect to an existing PostgreSQL database using a Windows 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. Go to the system where the existing database is located and select Start - Programs - PostgreSQL - pgAdmin
III. The pgAdmin software opens.
3. In the tree, double-click PostgreSQL Database Server (localhost) to expand the directories.
4. Double-click Databases, right-click on AMPDB and select New Object - New Database. The New Database
dialog box opens.
5. Enter a name for the new database and in the Encoding field, select UTF8 from the drop-down list. This is
acceptable for both Window Server and Linux servers. Click OK. The new database is listed in the tree.
6. Select Start - PostgreSQL - Configuration files - Edit pg_hba.conf. The notepad opens.
7. Scroll to the bottom and locate #IPv4 local connections:
8. Go to the line host all all (IPlocalhost address) md5. Press Enter.
9. On the blank line, enter host all all 0.0.0.0/0 md5.
10. Select File - Save, then File - Exit and select Start - PostgreSQL - Configuration files - Edit postgresql.conf.
The notepad opens.
11. Select Edit - Find, enter localhost and click Find Next.
12. Under connections and authentication, delete the # in front of listen_addresses and change localhost to an
asterisk (*).
13. Select File - Save, then File- Exit.
14. Select Start - PostgreSQL - Stop service.
15. Select Start - PostgreSQL - Start service.
16. Exit the pgAdmin III software.
17. Close the system where the new database was created.
18. 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.