PostgreSQL as a supported content store and audit store database

As of release 12.0.4, you can use PostgreSQL as a content store and an audit store database.

Important: PostgreSQL is not supported as a Mobile Reports database.

Adding PostgreSQL as a content store database

Follow these steps to add PostgreSQL as a content store type in IBM® Cognos® Configuration.

Important: The minimum supported PostgreSQL version for Content Manager is 16. A PostgreSQL driver is also required, but it is not present in a default IBM Cognos Analytics server installation.
  1. Open IBM Cognos Configuration.
  2. In the Explorer, go to Data Access and right-click the Content Manager.
  3. Hover over the New resource option, and then choose Database.
  4. Name the new resource and select PostgreSQL Server database option from the drop-down list.
Process of adding PostgreSQL as a new database in IBM Cognos Configuration.

To learn more about creating and configuring a PostgreSQL content store, see the following topics:

Adding PostgreSQL as an audit store database

By default, the file system stores the audit logs as log files. However, to run a report, the audit logs must be stored in a database.

To set up PostgreSQL as an audit store database, make sure that the PostgreSQL driver is in the drivers folder, and then follow these steps:

  1. Open IBM Cognos Configuration.
  2. In the Environment section, right-click Logging, select New Resource, and then Destination.
  3. Choose Database, and then enter its name.

    In this example, the database name is Audit.

  4. Right-click the entry that you created and choose Database.
  5. Select PostgreSQL from the drop-down list and enter database connection information.
Complete set up of PostgreSQL as an audit store database in IBM Cognos Configuration.

To learn more about creating and configuring a PostgreSQL audit database, see the following topics: