Enabling or disabling Postgres Sync Replication

You can configure the watsonx Assistant to enable or disable Postgres Sync Replication by editing the Custom Resource or by applying the patch commands.

Note: You must use only Method 1 or Method 2 to enable or disable Postgres Sync Replication.

Method 1: By applying patch command

To disable Postgres Sync Replication, use the following patch command:

oc patch wa wa --type=merge -p="{\"configOverrides\":{\"postgres\":{\"sync_replication\":\"disable\"}}}"

Method 2: By editing Custom Resource

Postgres Sync Replication is disabled by default. To enable it, edit the watsonx Assistant Custom Resource.

oc project ${PROJECT_CPD_INST_OPERANDS}
export INSTANCE=`oc get wa -n ${PROJECT_CPD_INST_OPERANDS} |grep -v NAME| awk '{print $1}'`
oc edit wa $INSTANCE
oc patch wa wa --type=merge -p="{\"configOverrides\":{\"postgres\":{\"sync_replication\":\"enable\"}}}"

You can add an override value to enable Postgres Sync Replication:

configOverrides:
  postgres:
    sync_replication: enable

To disable Postgres Sync Replication, remove the value from the Custom Resource.