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.
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...
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...
Aziz Rahman · April 26, 2019
The Benefits of Databases in Containers Highly available databases allow organizations to run database operations around-the-clock, providing...
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...
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.
- Developer Resources
- High Availability
- Replication and Failover
- Performance Tuning
- Performance Monitoring and Alerting
- Containers, Kubernetes, Docker
- Oracle To Postgres Migration
- DBA and Admin Resources
- Tools and Extensions
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.
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