The story on the development of a database change management solution and what we lacked in Liquibase and Flyway
We will tell you how we store database objects in the version control system. Then we compare the traditional approaches to manage database migrations and the one we preferred. We will talk about both methods advantages and disadvantages. Finally, we will present our change management solution - pgmig.
Слайды
pgConf2023_pgmig_v3.pptxВидео
Видео доступно участникам мероприятия, выполнившим вход в личный кабинет
Другие доклады
-
Vasiliy Puchkov ООО
Odyssey of corporate-scale migration to PostgreSQL
- Scylla Charybdis of project management;
- Sirens of personal goals:
- Circe for IT professionals:
- Polyphemus of information security.
The tricky part of taking the journey in less than ten years.
-
Maksim Afinogenov АО "ОКБМ Африкантов"
Experience in porting the production management system database from Oracle DBMS to PostgresPro DBMS in a manufacturing enterprise
The practice of transferring structure, logic and data from Oracle DBMS to PostgresPro DBMS. Features and main difficulties of migration. Advantages of PostgresPro in terms of porting logic.
-
MMikhail Maslov Банк ВТБ (ПАО)
Multi-transactions and possible issues with them
In this presentation, we cover multi-transactions, explain when they appear and how they can be monitored and checked. We also tackle the possible issue with multi-transaction ID wraparound and the problem of file absence in pg_multixact/offsets when restoring from a backup.
-
Alfred Stolyarov ООО "Еваппс" (EvApps)
How we switched Oracle for PostgreSQL for a client, before it became mainstream
The history of import substitution did not start last year after well-known events. Its launch dates back to 2014. It was from this year that state and near-state companies began to think of switching to the so called "recommended software". One of these companies approached us back in 2020 with a project to move from Oracle to PostgreSQL. This project was designed to solve the accumulated architectural problems (imperfect storage system for telemetry data, the DBMS itself worked inside a virtual machine), and optimize the use of disk space (make space in the main storage, debug saving archived data, ensure correct backup). Since the customer's system should have worked uninterrupted 24/7, it was necessary to switch from one DBMS to another "seamlessly" without downtime, with simultaneous operation of both to ensure step-by-step translation of subsystems and the ability to control the correctness of the data. And, of course, the work had to be completed as quickly as possible.
In the report we will discuss how we managed to solve this case.