The command patronictl reinit gives the "Error <member_name> is not a member of cluster" in VMware Postgres

Products

• VMware Tanzu Greenplum

Issue/Introduction

When running patronictl -c <YAML file> reinit, it outputs the following error:

-bash-4.2$ patronictl -c /var/lib/postgresql/postgres2.yml reinit patroni_test postgresql2
+--------------+-------------+----------------+--------+---------+----+-----------+
|   Cluster    |    Member   |      Host      |  Role  |  State  | TL | Lag in MB |
+--------------+-------------+----------------+--------+---------+----+-----------+
| patroni_test | postgresql0 | 10.193.102.203 | Leader | running | 10 |         0 |
| patroni_test | postgresql1 | 10.193.102.204 |        | running | 10 |         0 |
| patroni_test | postgresql2 | 10.193.102.205 |        | running |  4 |        64 |
+--------------+-------------+----------------+--------+---------+----+-----------+
Error: postgresql2 is not a member of cluster

Environment

Product Version: 11.6

Resolution

Assuming the Patroni process is running on the host, try the following workaround:

1. Stop Patroni on all members of the cluster.

2. Start Patroni on all hosts of the cluster.

3. Run renit to sync with the leader.