Cross-Region Database

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.