Follow my Leader - connecting Postgres client applications after server failover

During a planned changeover, or after the failure of a primary, smoothly promoting a Postgres replica is not the end of the problem. It’s the start of a new phase of the problem - getting the clients connected to the right Postgres instance.

Making sure that client applications only try to write to the primary can be done in many places, from the client library in the application to the network configuration of the servers. Picking the best option is not just about technical correctness or elegance. Decisions also affect the ease of change, consistency across the environment, complexity of each deployment and costs.

Join me for an overview of where DBAs, application teams and network teams can take control of how applications connect after a changeover, and how to pick an option.