Presented by:

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!

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:
Duration:
45 min
Room:
Conference:
PGConf India, 2019
Language:
Track:
Database Administration
Difficulty:
Intermediate