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:
-
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
- The following configurations are needed only if Apache NiFi-based connectors are installed:
- Open the prdconfigdb.properties file from the following location:
cd $install_dir/connector/nifi-1.8.0/conf/
vi prdconfigdb.properties
Replace localhost with HAProxy IP address for the following
parameter:
prdconfigdb_host=localhost
- Open the PRD_Connector_Tenant_Creator.sh file from the following location:
cd $install_dir/connector/scripts/
vi PRD_Connector_Tenant_Creator.sh
Replace localhost with HAProxy IP address for the following
parameter:
databaseConnectionUrl="jdbc:postgresql://localhost:5432/prddb"
- Open the PRD_Connector_Uninstall_DB_Setup.sh file from the following location:
cd $install_dir/connector/scripts/
vi PRD_Connector_Uninstall_DB_Setup.sh
Replace localhost with HAProxy IP address for the following
parameter:
databaseConnectionUrl="jdbc:postgresql://localhost:5432/prddb"
- Restart Cloud Application Business Insights server.