Postgres replica not streaming data from the master after upgrade in Aria Operations

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

The alert "Postgres data replication is not working" was triggered after upgrading Aria Operations.

To check if the alert is a false positive,  run the following commands:

• Run on Primary node:
  
  su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433 -c 'select * from pg_stat_replication;'"
  
  
• Run on Replica node:
  
  su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433 -c 'select * from pg_stat_wal_receiver;'"

If there is no entry in the tables, the alert is valid.

Environment

Aria Operations 8.x

Resolution

If the alert is false positive, please cancel and delete the alert. The alert should not return if it is a false positive.

If the alert is positive, meaning the replication row is equal to zero. Please fully reboot the Aria Operations as per the following steps.

How to fully reboot Aria Operations:

• Log in to Admin UI (https://vrops_fqdn/admin) with local admin
• Click on Take Cluster Offline.
• Once the cluster is offline, log in to vCenter
• Restart the Guest OS for the Aria Operations VMs.
• Once they are fully loaded, go back to the Aria Operations Admin UI page
• Click on Bring Cluster Online.