PostgreSQL

What is leader election? A common scenario where leader election is needed is running scheduled (cron) jobs in a backend service that has multiple instances. If you have just one instance, life is simple — that instance runs all the jobs. But when you scale horizontally and run multiple instances, you want to make sure that a scheduled job runs only once, on one leader instance — not duplicated across all instances. This is where leader election comes in. ...