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:

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.