Oracle to PostgreSQL Migration with Near Zero Downtime

on YouTube ↗51m

" summary

Claim: a live migration from Oracle RAC to PostgreSQL HA succeeds with near zero downtime. Process uses Oracle GoldenGate + oracle_fdw + ora2pg for phased cutover, a migration server to stage trail files, and Patroni/Percona operator on GKE for the target. Challenges include NUMBER precision/scale changes, large 200 TB data volume, timestamp and charset quirks, no global indexes or global temporary tables, TOAST and autocommit semantics. Result: moves 200 TB, sustains ~200 TPS (~800 DB ops/sec) and cuts licensing and scaling cost.

AI-written summary · about

" chapters (10)

1. 0:00Introduction and context
2. 3:09Project goals and design
3. 6:52Oracle architecture review
4. 10:31Postgres architecture
5. 12:52Migration phases and hurdles
6. 16:26Technical migration lessons
7. 25:38Migration tools and process
8. 36:07Data synchronization details
9. 44:26Postgres performance and ops
10. 49:26Kubernetes and operators

" related talks

• 06mMigration Consideration Oracle to PostgreSQLNeeta Goel · PGConf India 2025
• 29mTales from the Field - Oracle to PostgreSQL migrationsAdithya Kumaranchath · POSETTE: An Event for Postgres 2024
• 01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & ExtensibilityShayon Sanyal · Postgres Conference Orlando 2025
• 37mDatabase Modernization at Cloud Scale: Minimizing Risk and DisruptionRama Chandra Murthy · Distributed SQL Summit Asia 2022
• 42mBBM’s 150M+ users Oracle to Postgres migration without downtimeÁlvaro Hernández · HighLoad++ Moscow 2018
• 42mMigrating a database over 10TB from DB2 to PostgreSQL with zero downtimeDmitriy Pogibenko · РИТ++ 2017
• 24mMigrating from Oracle to Azure Database for PostgreSQL, SeamlesslyNeeta Goel, Sandeep Rajeev · POSETTE: An Event for Postgres 2025
• 48mMigrating to PostgreSQL: Strategies, Sovereignty, and SuccessRaphael Salguero · PostgreSQL Conference Europe 2025