2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Products2 / PostgreSQL High Availability

Achieving High Availability with PostgreSQL

Setup and Deploy Enterprise-Grade High Availability for PostgreSQL Clusters

Critical business applications require availability of their backend database cluster at all times. 2ndQuadrant provides enterprise-grade solutions for both Single Master and Multi-Master architectures. These solutions allow deployment of Highly Available PostgreSQL with Rolling Upgrades, Fast Failovers, Point-in-Time Recovery, and more. 

The Single Master architecture provides High Availability of up to four 9s, while the BDR-based architecture provides AlwaysOn Availability of up to six 9s. These architectures are designed based on industry best practices and provide high levels of reliability for production use.

High Availability Options

1. AlwaysOn PostgreSQL with BDR

Diagram: AlwaysOn PostgreSQL. A reference architecture by 2ndQuadrant known as Trusted PostgreSQL Architectures (TPA) which is ideal for businesses with requirements of high availability in multi-master clusters.

AlwaysOn PostgreSQL with BDR offers up to six 9s of availability and is designed for geographically distributed databases, minimizing latency, and providing geofencing capabilities. Based on ground-breaking BDR technology, it allows Advanced Clustering and Scaling of a database cluster as well as Automatic Conflict Resolution for DDL and DML replication. 

Whitepapers from 2ndQuadrant will help you develop a deeper knowledge about PostgreSQL, its tools, and highlight some of the common issues faced by day-to-day Postgres users and possible solutions to overcome them.Download Whitepaper: Multi-Master Replication in PostgreSQL

Find out more about BDR features and deployment options

2. Highly Available PostgreSQL

Diagram: Highly Available PostgreSQL Clusters - 2ndQuadrant’s recommended reference architectures (Trusted PostgreSQL Architectures) for businesses operating a single master with High Availability requirement. This architecture utilizes three open source PostgreSQL extensions: PgBouncer, repmgr, and Barman.

Highly Available PostgreSQL clusters provide up to four 9s of availability. Whether a planned switchover or unplanned failure, the Failover solution ensures the database cluster remains available for your application. Additionally, the Highly Available PostgreSQL cluster comes with a built-in backup strategy and recovery plan.

Whitepapers from 2ndQuadrant will help you develop a deeper knowledge about PostgreSQL, its tools, and highlight some of the common issues faced by day-to-day Postgres users and possible solutions to overcome them.

Download Whitepaper: Highly Available PostgreSQL

High Availability Features

Disaster Recovery to Ensure Continued Availability

To maximize the availability of business-critical solutions, a comprehensive Disaster Recovery Strategy is crucial. Planning for Disaster Recovery preempts data loss. Achieve your Recovery Time and Recovery Point Objectives with solutions built in to our High Availability architectures. Barman – Backup & Recovery Manager from 2ndQuadrant – is the best tool to ensure continued availability. Discover how Barman can help you secure your business critical PostgreSQL databases. 

Learn More

Rapid Switchover And Load Balancing

Load balancing is essential in achieving enterprise-grade High Availability with PostgreSQL. It ensures that no single node is overwhelmed with data traffic, resulting in optimal performance across all available nodes. Our AlwaysOn solution also provides the ability for Rapid Switchover by using load balancing tools to quickly promote a Shadow Node attached to a Master that may no longer be available.

Learn More

Database Security

Hardening your database is essential in order to comply with regulations such as GDPR, PCI, and DSS. 2ndQuadrant provides high availability environments with protection against vulnerabilities, covering your PostgreSQL from operating system to schema level. The trusted architectures cover security aspects such as user management, network, data encryption, and more. A Security Audit by 2ndQuadrant will identify and address security threats to harden your PostgreSQL database and infrastructure.

Learn More

24/7 Production Support

Database downtime can cost a business millions of dollars.. To minimize business risk and ensure peace of mind that if an issue arises it will be handled quickly, 2ndQuadrant provides 24/7 Production Support for its high availability architectures. Our world-renowned support is a cost-effective and scalable solution with a guaranteed response time of 15 minutes and bug fix of 24 hours. 2ndQuadrant provides different plans for 24/7 Production Support, all guaranteeing fast response and resolution times.  

Learn More

What Our Customers Say

“We can certainly attribute help in our growth to Postgres-BDR (high availability) since we now have consistent performance globally and are able to grow our business in multiple regions.”
– Alex Yurkowski, CTO, ClickUp

High Availability Knowledge Base

Whitepapers

Whitepapers from 2ndQuadrant will help you develop a deeper knowledge about PostgreSQL, its tools, and highlight some of the common issues faced by day-to-day Postgres users and possible solutions to overcome them.

Multi-Master Replication in PostgreSQL
A deeper look into the scenarios when designing an ‘Always On’ architecture for PostgreSQL in a business environment.

Download Whitepaper

Highly Available PostgreSQL Whitepaper
This whitepaper discusses the scenarios when designing a high availability architecture for PostgreSQL, including failover and switchover.

Download Whitepaper

Videos

‘Enhancing Postgres High Availability’ Webinar

Postgres High Availability is not just about putting together the right pieces. This webinar answers questions such as choosing HA components and what can go wrong, how to prevent edge cases and build a cluster that is “Always On” in the face of Network Partitions, Split Brain and other looming specters, and what role Multi Master can play.

Watch Video

‘Achieving High Availability with PostgreSQL’ Webinar

This webinar covers overview of High Availability concepts, High Availability with PostgreSQL streaming replication, setting up a streaming replication cluster, best practices, failover and switchover – Reconfiguring application setup, pros and cons of Automatic vs Manual Failover, Backups and High Availability.

Watch Video

Next-Generation PostgreSQL Replication by Peter Eisentraut

This presentation talks about PostgreSQL replication solutions that provide asynchronous bi-directional multi-master replication (BDR) through publish/subscribe models, that work exceptionally-well for geographically distributed databases.

Watch Video

Books

PostgreSQL High Availability Cookbook – Second Edition

Master over 100 recipes to design, implement, and manage a highly available database with the advanced features of PostgreSQL. This book will teach you all the tips and tricks of creating high availability clusters that are robust, secure, scalable, and resistant to data-corruption. 

How Tos

Learn how to incorporate high availability in your PostgreSQL database with detailed tutorials provided by 2ndQuadrant Experts.

Automated rapid switchover with a BDR database cluster in Kubernetes

Explore this tutorial on how BDR and Kubernetes allow you to reach very high uptimes for a PostgreSQL database solution with rapid switchover capability.

How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1

Learn how repmgr and the repmgrd daemon can automate High Availability and Failover of a three-node PostgreSQL12 cluster.

How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2

See how a multi-node PostgreSQL cluster can be made to auto recover its High Availability after Failover.

High Availability Tools

repmgr 

Simplified management of Replication, Failover, and Switchover for PostgreSQL Clusters

Barman 

Backup and Disaster Recovery Manager for PostgreSQL

Training

2ndQuadrant offers online, in-person, and on-site training for a variety of courses to improve your understanding and practical knowledge of PostgreSQL.

Replication, Backup & Disaster Recovery

This course covers the basics of replication, backup, and recovery through administration and application of design.

PostgreSQL Database Administration 

This course covers the tasks that a database administrator faces daily, from basic operations to managing critical databases.

PostgreSQL Immersion

This course is a self-contained program, created by combining selected topics from three other comprehensive courses: Administration and Replication; Advanced Development and Performance; and Backup & Disaster Recovery.

Blogs

Webinar: Enhancing Postgres High Availability [Follow Up]

July 16, 2020/0 Comments/in Webinars /by Adnan Nazar

Postgres High Availability is not just about putting together the right pieces. We should also consider the following: Why did we choose those components?  What can go wrong?  How do we prevent edge cases from ruining our day? Can we possibly build a cluster that is “Always On” in the face of Network Partitions, Split […]

Read more

Failover slots for PostgreSQL

June 8, 2020/8 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

Logical decoding and logical replication is getting more attention in the PostgreSQL world. This means we need it working well alongside production HA systems – and it turns out there’s a problem there. Replication slots are not themselves synced to physical replicas so you can’t continue to use a slot after a master failure results […]

Read more

How to deploy a multi-master BDR cluster in Kubernetes

June 8, 2020/0 Comments/in Cloud Native /by Gabriele Bartolini

Discover in this article and video how BDR can be easily and quickly deployed on Kubernetes thanks to our Cloud Native BDR Operator. BDR is a full mesh replication solution for PostgreSQL databases developed by 2ndQuadrant that provides both high availability and multi-master capabilities. It is now available for Kubernetes on Public and Private environments, thanks to 2ndQuadrant’s Cloud Native BDR Operator and […]

Read more
View All Blogs
Back to top

Get in touch with us!

Please fill in the form below and we'll be in touch as soon as possible.

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scroll to top
×