Rollback: Major Version Upgrade, Minimum Downtime, Multi Terabyte DB
Presented by:

Nikhil Shetty
Nikhil Shetty is a Database engineer at Apple. He has a total of 8 years of experience as a PostgreSQL DBA. He is a passionate learner and has firm grip on key concepts of PostgreSQL. He is also a cloud enthusiast and has professional certifications in multiple cloud technologies. In his free time he likes to play football or cricket or watch movies

Siva Mekala
Siva Mekala is a Database engineer at Apple. He has a total of 8 years of experience as a PostgreSQL DBA. He is also a cloud enthusiast who loves to explore and develop cloud technologies and see how best they can be utilised for PostgreSQL. He is passionate about automation and likes to automate anything that is required to be done repetitively. In his free time he likes to watch movies
No video of the event yet, sorry!
Objective
To discuss about the rollback option with minimum downtime on a multi terabyte DB after major version upgrade
What are we going to talk about?
We will be talking on what are the different approaches that we can have to roll back to the older version in minimal time.
A) Rollback after completion of upgrade
Rollback with zero data loss to the older DB version.
Rollback with minimal data loss to the older DB version.
B) Rollback during the upgrade process
- Date:
- 2023 February 24 - 14:00
- Duration:
- 45 min
- Room:
- Grand Victoria 2
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Database Administration
- Difficulty:
- Medium
- MERGE: Built to Remove Barriers
- Start Time:
- 2023 February 24 14:00
- Room:
- Grand Victoria 1
- How unused indexes, fragmentation and idle connections slow down DB performance
- Start Time:
- 2023 February 24 14:00
- Room:
- Robusta + Arabica