Presented by:

Faadfe73f3a32aa7de2b32c8dd981d6d

Bhargav kamineni

from Percona
7ba4aff2cc2eb5c4a24a3f9b7f321571

Sagar Jadhav

from Percona
No video of the event yet, sorry!

Training coverage: 1. Introduction to Logical Replication - Overview of PostgreSQL replication options: physical vs. logical - Benefits and use cases for logical replication - How logical replication fits into PostgreSQL's architecture

  1. Setting Up Logical Replication

    • Prerequisites and environment setup
    • Configuring publisher and subscriber
    • Step-by-step guide on creating a publication and subscription and adding tables to the replication
  2. Use Cases and Applications

    • Real-time reporting and analytics
    • Data migration between PostgreSQL versions
    • Others
  3. Failure Scenarios in Logical Replication

    • Common causes of replication failure (network issues, disk space, data conflicts)
    • Recognizing replication lag and synchronization issues
    • Issues with the replication slots
    • Things to consider while replication in progress
    • Handling schema changes and role management issues

Date:
Duration:
3 h 30 min
Room:
Conference:
PGConf India, 2025
Language:
Track:
Training
Difficulty: