Postgres Database

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:

  1. In the Data Source field, type Database.
  2. In the Description field, type a description for your cross-region database. In this case, type Postgres Database.
  3. In the Database field, type postgres.
  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.