EnterpriseDB/repmgr

feat request: populate %p when standby_promote event occurred

Opened this issue · 2 comments

I need to know node ID of the demoted primary when standby_promote event occurred, similar to the standby_switchover event.
I need this feature to shutdown the demoted primary server through aws cli on standby_promote event to prevent split-brain and perform node level fencing.

We've looked into this and determined that repmgr standby promote by itself can't be sure which primary it's replacing.

What's the precise context where you need this? If it's when using repmgrd, it would be possible to provide this with the repmgrd_failover_promote notification.

Hello Ian!

I need to know the node ID of the demoted primary in order to shutdown that server to prevent split-brain and to perform node level fencing.

Right now I'm querying all failed nodes in the event notification script from the repmgr.nodes table and shutting them down, but this is not a good approach, because there maybe be nodes that I don't want to shutdown.