What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic
Tags: postgres, infographic, uptime, database
Published: 2019-10-31 16:31:24

---
title: What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic
published: true
description: Compare top PostgreSQL high availability frameworks PostgreSQL Automatic Failover (PAF), Replication Manager (repmgr) and Patroni to improve uptime - ScaleGrid Blog
tags: PostgreSQL, Infographic, Uptime, Database,
canonical_url: https://scalegrid.io/blog/whats-the-best-postgresql-high-availability-framework-paf-vs-repmgr-vs-patroni-infographic/
---
<link rel="canonical" href="https://scalegrid.io/blog/whats-the-best-postgresql-high-availability-framework-paf-vs-repmgr-vs-patroni-infographic/" />

<a href="https://scalegrid.io/blog/whats-the-best-postgresql-high-availability-framework-paf-vs-repmgr-vs-patroni-infographic/"><img src="https://scalegrid.io/blog/wp-content/uploads/2019/10/Best-PostgreSQL-High-Availability-Framework-PAF-vs-repmgr-vs-Patroni-Infographic-ScaleGrid-Blog.png" width="100%" height="auto" alt="What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic - ScaleGrid Blog"></a>
<p style="text-align: justify;">Wondering which high availability framework to use for your <a title="PostgreSQL Hosting" href="https://scalegrid.io/postgresql.html" target="_blank">PostgreSQL deployments</a>? We compared the top 3 frameworks, <a title="PostgreSQL Automatic Failover (PAF)" href="https://scalegrid.io/blog/managing-high-availability-in-postgresql-part-1/" target="_blank">PostgreSQL Automatic Failover</a> (PAF) vs. <a title="Replication Manager (repmgr)" href="https://scalegrid.io/blog/managing-high-availability-in-postgresql-part-2/" target="_blank">Replication Manager</a> (repmgr) vs. <a title="Patroni" href="https://scalegrid.io/blog/managing-high-availability-in-postgresql-part-3/" target="_blank">Patroni</a>, 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.</p>

<h2 style="text-align: left; padding-top: 15px;">PostgreSQL High Availability Framework Infographic</h2>
<p style="text-align: justify;">Given the popularity of these posts, we condensed the results into the below <a href="https://scalegrid.io/blog/whats-the-best-postgresql-high-availability-framework-paf-vs-repmgr-vs-patroni-infographic/">infographic</a> so you can easily visualize and compare how the top frameworks handle these common failure scenarios.</p>

<div style="padding: 20px 0px 35px 0px;">


<a href="https://scalegrid.io/blog/whats-the-best-postgresql-high-availability-framework-paf-vs-repmgr-vs-patroni-infographic/"><img src="https://mongodb.scalegrid.io/hubfs/Best-PostgreSQL-High-Availability-Framework-PAF-vs-repmgr-vs-Patroni-Infographic-ScaleGrid-Blog.png" width="100%" height="auto" alt="What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic - ScaleGrid Blog"></a>

<p style="text-align: justify; padding-top: 15px;">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 <a href="https://twitter.com/scalegridio" target="_blank">@scalegridio</a>!</p>

<div style="padding: 20px 0px 30px 0px;">


</div>
<p style="text-align: justify; padding-bottom:20px;">If you need help setting up high availability for your PostgreSQL clusters, check out our fully Managed <a href="https://scalegrid.io/postgresql/aws.html" target="_blank">PostgreSQL on AWS</a>, <a href="https://scalegrid.io/postgresql/azure.html" target="_blank">PostgreSQL on Azure</a>, and <a href="https://scalegrid.io/platforms/enterprise-on-premise.html" target="_blank">PostgreSQL Enterprise</a> solutions to automate your database management in the cloud an on-premise. We work with thousands of DBA's, DevOps engineers, and developers to improve their availability, performance and security, and would love to help you out as well. Explore the platform in a <a href="https://console.scalegrid.io/users/register" target="_blank">free 30-day trial</a> - no credit card required, or visit our <a href="https://scalegrid.io/postgresql/hosting-comparison.html" target="_blank">Compare PostgreSQL Providers</a> page to see why we're the #1 PostgreSQL hosting solution.</p>