Thursday, April 20, 2023

Postgres: ERROR: this node should be a standby

On a standby node, while performing a clone. I am receiving an error. So, I am on Standby and nothing's incorrectly done on the repmgr.conf either.

 repmgr -h 10.18.10.11 -U repmgr -d repmgr -f repmgr.conf standby clone



[postgres@center-2 ~]$ repmgr -f repmgr.conf standby register -F
INFO: connecting to local node "centos-2" (ID: 2)
ERROR: this node should be a standby (host=10.18.10.11 port=5432 dbname=repmgr user=repmgr)

Reason the clone was done without the-F parameter. It should be done with -F to overwrite the original. The error definitely bogus.

repmgr -h 10.18.10.11 -U repmgr -d repmgr -f /var/lib/pgsql/repmgr.conf standby clone -F

No comments:

Post a Comment