Migration from Oracle PL/SQL to Postgres pl/pgSQL: Two Years Later

Anatoly Anfinogenov

VNIIZHT JSC (a subsidiary of RZD OJSC)

Deputy Director of the Research Center, Head of VNIIZHT Software Development Department


In 2019 we migrated distributed railway application from Oracle 11g SE to vanilla PostgreSQL 11.9. Almost 2 years have passed, the system is working good. The report focuses on how we migrated, what problems we faced during this migration and after migration, as well as what we would have done differently today experience.

Slides →