How to migrate logical replication slot to new primary during physical cluster switchover
Presented by:

Tushar Takate
Tushar Takate
is a Database engineer at Apple. He has a total of 8+ years of experience as a PostgreSQL DBA, and 3+ years of association with Apple. Throughout his Database engineer/DBA journey, his prime focus has been in supporting large-scale and complex applications which run on PostgreSQL and ensuring to have them highly available. He has always been proactive and keen to adopt new tools/use cases or develop a home-grown solution to fulfill business requirements and fine tune them.
No video of the event yet, sorry!
Objective
To present the architecture of the solution which we have designed for migrating logical replication slot when there is a situation of physical cluster switchover/failover.
What are we going to talk about?
We will be talking about:
A) How this solution/idea is different than others?
B) How to move/reset restart_lsn in the past of logical replication slot when there is a need (Kind of PITR).
- Date:
- 2023 February 24 - 12:00
- Duration:
- 45 min
- Room:
- Robusta + Arabica
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Database Administration
- Difficulty:
- Hard
- Rare but extremely challenging Postgres Performance Problems. How to diagnose and overcome
- Start Time:
- 2023 February 24 12:00
- Room:
- Grand Victoria 1
- Bug hunting in the postgres ecosystem
- Start Time:
- 2023 February 24 12:00
- Room:
- Grand Victoria 2