Robust Replication strategies in PostgreSQL: Repmgr

Presented by:

4a4411b62dcf2f5da4f8f23a33c98e5b

Pallavi Sontakke

from 2ndQuadrant

At 2ndQuadrant India, Pallavi is a Lead QA and Release Engineer. She is working with 2ndQuadrant for nearly 4 years now. She is based in Pune.

No video of the event yet, sorry!

Download slides

*Robust Replication strategies in PostgreSQL: Repmgr * In today's business environments High Availability of your Databases is very important. PostgreSQL offers physical replication for this; Discussion on how Repmgr uses it to solve these issues.

Repmgr is an open-source tool suite for managing replication and failover in a cluster of PostgreSQL servers. It enhances PostgreSQL's built-in hot-standby capabilities with tools to set up standby servers, monitor replication, and perform administrative tasks such as failover or manual switchover operations.

Repmgr has provided advanced support for PostgreSQL's built-in replication mechanisms since they were introduced in 9.0. The current Repmgr series, Repmgr 4, supports the latest developments in replication functionality introduced from PostgreSQL 9.3 such as cascading replication, timeline switching and base backups via the replication protocol.

Date:
2019 February 15 - 12:00
Duration:
45 min
Room:
Ballroom 3
Conference:
PGConf India, 2019
Language:
Track:
Application Developer
Difficulty:
Intermediate

Happening at the same time:

  1. EXPLAIN: Understand the query plan
    2. Start Time:
    2019 February 15 12:00

    Room:
    Ballroom 1

  2. Postgresql HA on Cloud using Kubernetes
    3. Start Time:
    2019 February 15 12:00

    Room:
    Ballroom 4