what causes entries in repmgr.nodes table to be lost
vhpriya16 opened this issue · 1 comments
Hi,
after a failover (believe it's after failover, didn't check if the table had any entries before the failover), I don't see any entries in the repmgr.nodes table. what causes the entries to be lost from this table ?
Pls suggest how we can repopulate the entries in this table with the latest cluster configuration ?
we are currently using repmgr 4.0.6
For starters, you are using an extremely old version of repmgr. I suggest you upgrade to the latest version.
Second, The promoted standby should have all the data from repmgr.nodes. If it doesn't it means you have a replication issue. I would suggest investigating the issue by monitoring the rows in repmgr.nodes on all nodes and seeing if there are rows that get removed after a failover. Maybe test this in a dev environment.
To repopulate the nodes table, just register the nodes one by one, starting with the current primary node.