Schedule - FOSDEM PGDay 2024

Clustering in PostgreSQL: Because one database server is never enough (and neither is two)

Date: 2024-02-04
Time: 12:00–12:50
Room: PostgreSQL Devroom

In the world of database management, high availability and disaster recovery are key considerations for any organization that wants to ensure reliable access to its critical data. Clustering in PostgreSQL is one of the most effective ways to achieve both. In this talk, we will explore the ins and outs of PostgreSQL clustering, including the benefits and challenges of different clustering approaches, and how to set up a highly available and disaster-resilient PostgreSQL cluster.

We will dive into topics such as synchronous vs. asynchronous replication, load balancing, failover, and disaster recovery. We will also touch on some open source tools that are readily available to aid in PostgreSQL cluster management.

Slides

The following slides have been made available for this session:

Speaker

Umair Shahid