Skip to main content

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