Simplifying the Top Complexities While Migrating From Oracle to PostgreSQL

on YouTube ↗31m

" summary

Claims which convert Oracle idioms into working Postgres replacements: use statement_timestamp (not now) to match Oracle sysdate behavior; use Postgres tablefunc connectby or rewrite WITH RECURSIVE to emulate Oracle connect-by depth‑first order; replace PL/SQL associative arrays with a pl/tcl wrapper or JSON/array patterns shown; run aura2pg for schema conversion, pg_repack for online reorg, streaming vs logical replication tradeoffs, and Patroni for automated failover — demonstrations and code snippets are provided.

AI-written summary · about

" chapters (8)

1. 0:00Start
2. 1:46Oracle RAC
3. 6:42Replication and High Availability
4. 13:01Procedural Languages
5. 14:30Extensions for Visibility
6. 16:24Extensions for Maintenance
7. 16:58Scalability
8. 25:43Hierarchical Queries

" related talks

• 01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & ExtensibilityShayon Sanyal · Postgres Conference Orlando 2025
• 06mMigration Consideration Oracle to PostgreSQLNeeta Goel · PGConf India 2025
• 48mMigrating to PostgreSQL: Strategies, Sovereignty, and SuccessRaphael Salguero · PostgreSQL Conference Europe 2025
• 22mAccelerating PL/pgSQL Code Conversation When Migrating to PostgresDeepak Mahto · POSETTE: An Event for Postgres 2024
• 29mTales from the Field - Oracle to PostgreSQL migrationsAdithya Kumaranchath · POSETTE: An Event for Postgres 2024
• 45mSQL Server to PostgreSQL: Migration Challenges & SolutionsSameer Kumar, Roneel Rohitesh Kumar · FOSSASIA PGDay 2025
• 24mMigrating from Oracle to Azure Database for PostgreSQL, SeamlesslyNeeta Goel, Sandeep Rajeev · POSETTE: An Event for Postgres 2025
• 49mSELECT 'amazing features' FROM "postgresql"Kevin Davin · Voxxed Days Brussels 2024