Schedule - PGConf.EU 2015
Oracle to PostgreSQL: replication and migration
Date: 2015-10-29
Time: 09:30–10:20
Room: Palais I-III
Level: Intermediate
Is it possible to migrate multi terabyte production Oracle database to PostgreSQL? Can it be achieved without affecting our clients' workloads? In this session I would like to show case our Oracle to PostgreSQL migration project including challenges we faced, problems we encountered and solutions we have deployed.
Teradata Marketing Applications Infrastructure Department has embarked on a database unification project. The main goal of this project was standardising our database environment on PostgreSQL. In order to achieve this we had to migrate legacy Oracle databases to PostgreSQL. This task was quite a challenge because of database size and 24x7 constant utilisation. We used cross platform replication solution from 2ndQuadrant to achieve downtime window of just a few minutes. At the same time we customised this solution to best fit our project of replicating database with intention of standardising on PostgreSQL.
This session will focus on technical details of migration. I will discuss large scale database migration challenges such as replicating multi-billion row tables and tables consisting of hundreds of columns. Furthermore emphasis will be set on system's architecture, problems and their solutions and lessons learned.
