Join the webinar - Live Online

Disaster Recovery in PostgreSQL: What Every Oracle DBA Needs to Know

Disaster Recovery (DR) in PostgreSQL differs significantly from Oracle, and this webinar will help you bridge the gap. We’ll explore how PostgreSQL defines DR vs. HA, break down the key building blocks such as RPO, RTO, PITR, switchover, and failover, and map them to familiar Oracle concepts like RMAN restores and archived redo logs. You’ll also learn about PostgreSQL backup strategies, how to test and validate your DR plan, and hear lessons learned from real-world incidents, giving you practical insights to confidently plan and manage PostgreSQL DR.

Select your preferred time:

Session 1: Thur | October 9 | 08:00 AM - 09:00 AM (BST) | Targets Europe region
Session 2: Thur | October 9 | 11:00 AM - 12:00 PM (EDT) | Targets US region

Session Selection

Introduction

Why DR is different in PostgreSQL vs. Oracle.
DR vs HA: Which is which in PostgreSQL? Is there a difference?
Common assumptions Oracle DBAs bring and how PostgreSQL handles them differently.

PostgreSQL DR building blocks

Key terms: RPO, RTO, PITR, switchover, failover in the PostgreSQL context.
Mapping PostgreSQL DR concepts to familiar Oracle equivalents like RMAN (Recovery Manager) restore, DR testing, etc.

Testing & validating the DR plan

How to simulate failures and test recovery workflows (Oracle has flashback and restore points to test DR without impacting).
PostgreSQL has the DR as a hot standby, but can data changes be rolled back after testing in DR?

Backup strategies in PostgreSQL

Physical vs. logical backups.
WAL archiving and continuous archiving vs. Oracle archived redo logs.

Lessons learned from production incidents

2-3 anecdotes/case studies from real-world events.

Our keynote speaker, Umair Shahid, is a trusted expert in the PostgreSQL community with 20 years of experience, renowned for sharing innovative ideas and leading advancements in database solutions. He helps businesses make their databases fast, reliable, and cost-efficient. With PostgreSQL, he ensures your data is safe, your system runs smoothly, and everything grows as your business grows.

At Stormatics, Umair leads a talented team that solves complex problems, secures databases, and enhances their performance. Recognizing that every business is unique, the company creates tailored solutions to meet specific needs, whether it is making things faster, stronger, or ready for the future.

Umair shares his expertise at international conferences, through webinars, and in training sessions, empowering others to tackle challenging PostgreSQL issues. His previous experience with commercial PostgreSQL has spanned roles related to professional services and product management in major pure-play PostgreSQL organizations like EDB, 2ndQuadrant, OpenSCG, & Percona.