Connecting Cloud Application Business Insights to the cluster

After you set up the PostgreSQL HA cluster, you must configure Cloud Application Business Insights to connect to the remote PostgreSQL HA cluster.

Procedure

Complete the following steps to configure Cloud Application Business Insights to connect to Patroni cluster node:

  1. Replace localhost with IP address of HAProxy server in the following files:
    • Open the prddb_config.sh file from the following location:
      
      cd $install_dir/prddb/custom/
      vi prddb_config.sh
      Where: install_dir is the directory where you installed the application.

      Replace localhost with HAProxy IP address for the following parameter:

      PRD_DB_SVC_HOST=localhost

    • Open the bootstrap.properties file from the following location:
      
      cd $install_dir/wlp/usr/servers/prdapp/
      vi bootstrap.properties

      Replace localhost with HAProxy IP address for the following parameter:

      database.server=localhost

    • Open the prdutil_config.sh file from the following location:
      
      cd $install_dir/prdutil/
      vi prdutil_config.sh

      Replace localhost with HAProxy IP address for the following parameter:

      PRD_DB_SVC_HOST=localhost

  2. Restart Cloud Application Business Insights server.