Migrating from Oracle to PostgreSQL: Strategy, Tools, and Best Practices

Migrating from Oracle to PostgreSQL has become a key modernization strategy for organizations seeking cost optimization, open-source flexibility, and cloud readiness. However, a successful migration requires careful planning, the right migration approach, and appropriate tooling.

This session explores the primary motivations for migrating Oracle databases to PostgreSQL and outlines common migration methods used in both on-premises and cloud environments. It introduces widely used migration tools and highlights best practices that help ensure data consistency, performance stability, and reduced risk during migration.

The presentation also provides an overview of the Oracle-to-PostgreSQL migration process using the Ora2Pg tool, covering schema conversion, data migration, and validation considerations. Attendees will leave with a clear understanding of how to evaluate migration options and plan Oracle-to-PostgreSQL migrations with confidence.

Speakers:
Arun Kumar Samayam
https://www.linkedin.com/in/asamayam/

Co-Author:
Mastering PostgreSQL Administration

Phani Kadambari
https://www.linkedin.com/in/phanikadambari/

Co-Author:
Mastering PostgreSQL Administration

Y V Ravi Kumar
https://www.linkedin.com/in/yv-ravikumar/

Oracle Certified Master (OCM)
Oracle ACE Director Alum
Snowflake Data Superhero 2025

Co-Author:
Oracle Database Upgrade and Migration Methods
Oracle High Availability, Disaster Recovery, and Cloud Services
Oracle GoldenGate with Microservices
Oracle Global Data Services (GDS) for Mission-critical Systems
Oracle Cloud Infrastructure (OCI) GoldenGate
Mastering MySQL Administration
Mastering PostgreSQL Administration
FinOps for Snowflake

As always, we'll have brief introductions, ~30 minute presentation followed by open discussion. The main presentation will be recorded and posted on YouTube under the pgUS channel: https://www.youtube.com/@pgus.