For MSSQL or PostgreSQL installations, each connection to a database server instance requires a data source connection to
either the master database (MSSQL) or the postgres database (PostgreSQL).
Specify the ODBC driver setup for the postgres database:
Configuring in a Windows environment
- In the
Data Source field, type
Database.
- In the
Description field, type a description for your cross-region database. In this case, type
Postgres Database.
- In the
Database field, type
postgres.
- In the
SSL Mode field, select
disable.
- In the
Server field, type the location of the PostgreSQL server. In this case, type
localhost.
- 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.
- In the
User Name field, type
postgres.
- In the
Password field, type the postgres user's password.
- Click
Save.
Configuring in a UNIX environment
Open the
.odbc.ini configuration file and add an entry for the PostgreSQL postgres data source:
[PG.MASTER]
Driver = <driver-name>
Servername = <server-name>
port = <port-no>
Database = postgres
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.
- postgres
- Specifies the name of the default database supplied with the PostgreSQL server.