Understanding High Availability options for PostgreSQL

Presented by:

693b21a275c6fc7078ef9c63dbefaafb

Madan Kumar K

from ScaleGrid

Madan is a Member of the Technical Staff at ScaleGrid working on PostgreSQL solutions. Prior to ScaleGrid, he worked with NetApp on disaster recovery solutions for Oracle databases as part of SnapCenter team.

No video of the event yet, sorry!

Download slides

Configuring High Availability is critical for any production PostgreSQL deployment. High availability goes beyond the setup of streaming replication. You need to understand the implications of process failures, node failures & network partitions on your cluster. In this talk we will present in detail three popular options to setup high availability using PostgreSQL built-in Streaming replication.

  1. PostgreSQL Automatic Failover (PAF) using Pacemaker & Corosync
  2. Replication Manager
  3. Patroni

We will compare and contrast each of the three options and finally share the results of the detailed testing we have done on each of the three options.

Date:
2019 February 14 - 11:15
Duration:
45 min
Room:
Ballroom 1
Conference:
PGConf India, 2019
Language:
Track:
Database Administration
Difficulty:
Intermediate

Happening at the same time:

  1. Migrating from Oracle to Enterprise-Ready Postgres in the Cloud
    2. Start Time:
    2019 February 14 11:15

    Room:
    Ballroom 4

  2. The state of the art in logical replication: PGLogical and BDR
    3. Start Time:
    2019 February 14 11:15

    Room:
    Ballroom 3