Region Database

Configuring in a Windows environment

1. In the Data Source field, type MYPAC.
2. In the Description field, type a description for your region database. In this case, type PAC Database.
3. In the Database field, type MYPAC.
4. In the SSL Mode field, select disable.
5. In the Server field, type the location of the PostgreSQL server. In this case, type localhost.
6. In the Port field, type the port number to connect to the PostgreSQL server. In this case, it will be the default port, type 5432.
7. In the User Name field, type postgres.
8. In the Password field, type the postgres user's password.
9. Click Save.

Configuring in a UNIX environment

Open the .odbc.ini configuration file and add an entry for the Region Database data source:

[PG.REGION]
Driver = <driver-name>
Servername = <server-name>
Port = <port-no>
Database = MYPAC

where:

<driver-name>

Specifies the name of the driver as configured in the odbcinst.ini file; in the example above, that would be PostgreSQL.

<server-name>

Specifies the name of the server on which the database instance resides.

<port-no>

Specifies the port on which the database is listening, typically 5432.

MYPAC

Specifies the name of the PAC that this database will serve.