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

Presented by:

9b9f6b79ea10a944790f617aa7430629

Nikhil Shetty

from Apple

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

Ff8589602925d4369b63f8bc6241cf58

Siva Mekala

from Apple Inc

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

  1. Rollback with zero data loss to the older DB version.

  2. 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

Happening at the same time:

  1. MERGE: Built to Remove Barriers
    2. Start Time:
    2023 February 24 14:00

    Room:
    Grand Victoria 1

  2. How unused indexes, fragmentation and idle connections slow down DB performance
    3. Start Time:
    2023 February 24 14:00

    Room:
    Robusta + Arabica