Migrate logical replication during physical cluster switchover
Presented by:
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.
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