Suggested settings for creating the content store in PostgreSQL

The database that you create for the IBM® Cognos® Analytics content store must contain specific configuration settings.

Use the following guidelines when you create the content store in PostgreSQL:

  • Specify the character encoding.

    You can specify the character encoding during database creation. Select the UTF-8 encoding option because it supports all valid Unicode points.

    If needed, you can convert between encodings after you create the database. Some of the character encodings that you can switch to include:

    Character encoding Description

    UTF-8

    This character encoding is a default one in most PostgreSQL installations.

    SQL_ASCII

    This encoding is a default one if you do not specify one during installation. It's an 8-bit encoding that does not check for valid encoding sequences.

    LATIN1 (ISO 8859-1)

    You can use this encoding for western European languages.

    LATIN9 (ISO 8859-15)

    It is an updated version of the LATIN1 encoding with the Euro symbol.

    WIN1252

    You can use this encoding for Microsoft Windows environments.

  • Select the protocol.

    PostgreSQL uses a custom communication protocol that defines rules for handling queries between the server and the client. It supports both text and binary data transmission, allows asynchronous messages, and extended query handling.

    When you create a database, select PostgreSQL Protocol v3.0. This version is the most current one and all communication relies on it.

    Note: PostgreSQL supports the Protocol v2.0 too, but only for compatibility with databases that use the earlier protocol version.