Posted in

What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni – Infographic

Wondering which high availabilityframework to use for your PostgreSQL deployments? We compared the top 3 frameworks, PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni, in our Managing High Availability in PostgreSQL series. In these blogs, we dove deep into how the frameworks work, their setup requirements, pros and cons, and how they performed in standby server tests, primary server tests and network isolation tests (split brain scenario) to help you determine the best framework to improve the uptime for your PostgreSQL-powered applications.

PostgreSQL High Availability Framework Infographic

Given the popularity of these posts, we condensed the results into the below infographic so you can easily visualize and compare how the top frameworks handle these common failure scenarios.

What's the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

So, which PostgreSQL high availability framework are you leveraging for your application? We’d love to hear how it’s working for you, and how you’d like to improve the performance on your deployment. Let us know your thoughts in our comments, or send us a message on Twitter at @scalegridio!

ScaleGrid offers a fully managed MongoDB, MySQL, PostgreSQL and Redis on AWS, Azure, and DigitalOcean. Bring your own cloud account or host with us. Deploy standalone, replica sets or shards.

Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.