PostgreSQL High Availability

A fundamental principle for high availability in PostgreSQL is eliminating a single point of failure, having a reliable crossover, and early detection of database failure. The concept of High availability, failover, and replication are intertwined. In this archive, DBA's and System administrators can find tips, tricks, tutorials, and training resources to achieve high availability in different deployment environments.

What Does "Database High Availability" Really Mean?

Vibhor Kumar · April 7, 2020

For many of our customers, High Availability is a key concern. Their architects spend a lot of time in designing and planning for high availability of...

Top Tools to Manage Postgres in an Enterprise: Administration, Performance, High Availability, and Migration

Marc Linster · April 8, 2020

This blog post lists tools for managing Postgres in the enterprise for administration, performance tuning, recovery, oracle to Postgres migration and high availability. While this is a big topic, there are common denominators that we have seen in many Postgres projects.

Patching Minor Version in Postgres High Availability (HA) Database Cluster: Plans & Strategies for DBAs

Vibhor Kumar · May 5, 2020

This blog is part of a series that will discuss best practices for High Availability (HA) for Postgres databases. In a prior blog, I explained what...

A Discussion of High Availability Options for Postgres in Containers

Dave Page · July 30, 2019

A Comparison of EDB Postgres Failover Manager, Patroni, and Stolon Clustered containers running Postgres (either PostgreSQL or EDB Postgres™ Advanced...

Running Highly Available Postgres Databases in Containers

Aziz Rahman · April 26, 2019

The Benefits of Databases in Containers Highly available databases allow organizations to run database operations around-the-clock, providing...

Highly Available Databases: 5 Design Questions

EDB Team · April 5, 2019

High availability databases are essential to organizations depending on mission-critical, 24/7 access. The use cases of a highly available database...

How to Provision and Deploy Highly Available Postgres with Terraform and Ansible Automation Scripts

Kanchan Mohitey · March 13, 2020

The world loves Postgres. If you work with developers, data scientists or anyone wrangling data or you are one of them, you probably are already...

Get Postgres tips & tricks

Subscribe to our newsletter to get advanced Postgres how-tos.

Related Tutorials

Featured Webinar

EDB Failover Manager - Features and Demo

EDB Postgres Failover Manager (EFM) is a high-availability module from EnterpriseDB that enables a Postgres Master node to automatically failover to a Standby node in the event of a software or hardware failure on the Master.

Watch Now

Introducing Postgres Pulse Live

Free To Attend: Every other Monday 11AM ET

A biweekly blog and live video forum series built to offer insight into how we analyze problems and develop solutions using Postgres.

About Postgres Pulse Live

PostgreSQL Replication Server for High Availability

EDB Postgres Replication Server (EPRS) integrates existing databases with EDB Postgres to make this data available for enterprise-wide analytics, increase OTLP and reporting performance, or in multi-master mode to offer solutions for geo-dispersed organizations

In this tech guide, we describe the six things a developer should know about in terms of how easy it is to install, work with, and deploy Postgres as well as the unique capabilities and wide range of features that Postgres offers.

Download Now