Can I promote a slave node to be a master for insert/update/delete using Patroni once the original master goes down?


The whole point of Patroni is that you don't have to do that yourself, but that Patroni does it for you automatically.

The nodes communicate regularly via a distributed consensus store that decides who is online and who isn't, and arbiters who of the available nodes should become the leader.

You can also tell Patroni manually to switch leader, even if all nodes are up (a "switchover").

|improve this answer|||||
  • 1
    If Patroni fails over to a standby, the standby is promoted and will become the new primary, so it is open for reading and writing. – Laurenz Albe Oct 20 '19 at 19:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.