Geo: Disabled secondary causes issues in failover

In cases of failover, if replication is paused it causes issues when we try to convert a node to a primary.

Definition of Done:

• Update geo:set_secondary_as_primary so that it ensures the new primary is enabled.

Related Zendesk Ticket - https://gitlab.zendesk.com/agent/tickets/166972

CC: @fzimmer @cat @john_long