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.
- Open IBM Cognos Configuration.
- In the Explorer, go to Data Access and right-click the Content Manager.
- Hover over the New resource option, and then choose Database.
- Name the new resource and select PostgreSQL Server database option from the drop-down list.

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:
- Open IBM Cognos Configuration.
- In the Environment section, right-click Logging, select New Resource, and then Destination.
- Choose Database, and then enter its name.
In this example, the database name is Audit.
- Right-click the entry that you created and choose Database.
- Select PostgreSQL from the drop-down list and enter database connection information.

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