Jump to: navigation, search

Configuring CMS to Work with PostgreSQL

Important
PostgreSQL is supported starting from 8.5.304.xx release of the Genesys Knowledge CMS Please use the latest stable version of PostgreSQL.

Prerequisites

  • Create new database in PostgreSQL
  • Create user account to access the database

Configuring CMS

  1. Configure database properties in the Genesys Knowledge Center Cluster application.
  2. Open Genesys Administrator and navigate to Provisioning > Environment > Applications.
  3. Select the application defined for the Knowledge Center Cluster and click Edit.
  4. From the Options tab in the cms.cluster section, set the following options:
    • for option type set postgre value.
    • dbConnectionUrl - to JDBC connection string for connection to PostreSQL Server following the format:
      jdbc:postgresql://<host_of_PostgreSQL>:<port_of_PostgreSQL>/<CMS_DB_name>
    • dbUsername - set to the username that needs to be used to login to PostgreSQL.
    • dbPassword - set to the password for db account.
    Note: Description of options in cms.cluster section can be found in Configuration Options.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on May 29, 2018, at 12:32.