Schedule - PGConf NYC 2024

Using Logical Replication for Major Version Upgrades and Tenant Migrations

Date: 2024-10-02
Time: 14:00–14:50
Room: The Forum
Level: Intermediate
Feedback: Leave feedback

This session discusses how at Tines we use logical replication in PostgreSQL to facilitate major version upgrades and tenant migrations with minimal downtime. Participants will discover the concepts of logical replication and its different uses. We'll also discuss the use of pg_easy_replicate, a tool developed at Tines, which has been instrumental in performing seamless upgrades across 50+ production databases via blue/green setup with DNS based switchovers. The talk aims to provide practical insights into leveraging logical replication and pg_easy_replicate for efficient database transitions with minimal impact on operations.

Slides

The following slides have been made available for this session:

Speaker

Shayon Mukherjee