Unable to remove postgres standby cell in Cloud Director using API

Products

• VMware Cloud Director

Issue/Introduction

Unable to remove Postgres Standby Appliance using API - VMware Cloud Director Appliance API Schema Reference.

Environment

Cloud Director 10.6.x

Cause

Postgres Cluster is in a bad state and API is unable to remove Standby Cell.

Resolution

Before Begining use the VMware Cloud Director appliance API to make a note of the node IDs of the standby nodes in the cluster. See the VMware Cloud Director Appliance API Schema Reference.

Remove Standby Cell from Postgres using Repmgr

1. Log in directly or by using an SSH client to the OS of Primary VMware Cloud Director appliance cell. You must log in as a root user.

2. Change the user to postgres.

sudo -i -u postgres

3. Run the command to get the [ID] of the standby appliance cell to remove.

/opt/vmware/vpostgres/current/bin/repmgr -f /opt/vmware/vpostgres/current/etc/repmgr.conf cluster show

4. To unregister a standby node that is not running, you must provide the node ID.

/opt/vmware/vpostgres/current/bin/repmgr standby unregister --node-id=[ID] -f /opt/vmware/vpostgres/current/etc/repmgr.conf