PostgreSQL ODBC Driver for Cognos

In order for Cognos to connect to postgreSQL as a data source, the 32-bit posetgreSQL ODBC driver must be installed on the Cognos system. The driver can be downloaded from

https://odbc.postgresql.org/

Once the driver has been installed, restart the IBM Cognos Service.

Connection Limit

max_connections determines the maximum number of concurrent connections to the database server. The default is typically 100 connections and the connection limit needs to be increased for PostgreSQL.

•

Open the postgresql.conf file, and change the configured value for max_connections to at least 1000.

•

On Windows, postgresql.conf file can be found under <postgressinstalllocation>\<pgsqlversion>\data\postgresql.conf

•

On Linux machine ,postgresql.conf file can be found under /var/lib/pgsql/<pgsqlversion>/data/postgresql.conf

Restart the postgres service