Cross-Region Database

Configuring in a Windows environment

1. In the Data Source field, type CrossRegion.
2. In the Description field, type a description for your cross-region database. In this case, type Cross Region Database.
3. In the Database field, type $XREGN$.
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 cross-region database data source:

[PG.CROSSREGION]
Driver = <driver-name>
Servername = <server-name>
Port = <port-no>
Database = $XREGN$

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.

$XREGN$

Specifies the name of the cross-region database, and is always this value.