Migrate logical replication during physical cluster switchover
Presented by:
Anubhav Jain
is a Database Engineering Manager at Apple. He has total of 17 years of experience and has been with Apple for more than 9 years. He started his career as an Oracle DBA and later added PostgreSQL to his portfolio. He is passionate for technology and likes to keep up with what is going on in currently in that space. In his free time he likes to play cricket.
No video of the event yet, sorry!
Objective
Present the architecture for migrating logical replication to new primary after of physical cluster switchover/failover.
What are we going to talk about?
We will be talking about:
A) How is this solution different than others?
B) How to move/reset restart_lsn in the past of logical replication slot when there is a need (PITR).
- Date:
- 2023 February 24 - 12:00
- Duration:
- 45 min
- Room:
- Robusta + Arabica
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Database Administration
- Difficulty:
- Hard
- Bug hunting in the postgres ecosystem
- Start Time:
- 2023 February 24 12:00
- Room:
- Grand Victoria 2
- Rare but extremely challenging Postgres Performance Problems. How to diagnose and overcome
- Start Time:
- 2023 February 24 12:00
- Room:
- Grand Victoria 1