Mastering PostgreSQL Logical Replication: Introduction, Setup, Failures, and Best Practices
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
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
Use Cases and Applications
- Real-time reporting and analytics
- Data migration between PostgreSQL versions
- Others
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: