Mastering Large-Scale PostgreSQL Migration

on YouTube ↗26m

" summary

A company migrates PostGIS from 2.4 to 3.2 and PostgreSQL from 10 to 14 across many large clusters (up to 6 TB each) holding high-volume vehicle geodata. The approach uses pg_upgrade --link with a kept standby replica to avoid long single-node downtime, runs tests in Docker images built from CentOS7 using real backups, and automates extension upgrades and deprecated-function renames to achieve ~20-minute cutovers for large clusters.

AI-written summary · about

" chapters (9)

1. 0:00Introduction
2. 3:20Project context and stakes
3. 7:13Global migration strategy
4. 10:04Testing with Docker and prep
5. 14:21Migration steps in detail
6. 18:35PostGIS problems and fixes
7. 21:08PostgreSQL 10 to 14 migration
8. 23:19Conclusion and results
9. 24:05Q&A

" related talks

• 46mAn ultimate guide to upgrading your PostgreSQL installationIlya Kosmodemiansky · PostgresOpen Silicon Valley 2017
• 32mPostgreSQL The Hard WayJames Miller · PGConf Silicon Valley 2016
• 59mLarge Scale MySQL Migration to PostgreSQLDimitri Fontaine · Postgres Open 2012
• 48mMigrating to PostgreSQL: Strategies, Sovereignty, and SuccessRaphael Salguero · PostgreSQL Conference Europe 2025
• 50mAn ultimate guide to upgrading your PostgreSQL installationIlya Kosmodemiansky · PostgreSQL Conference Europe 2024
• 42mMigrating a database over 10TB from DB2 to PostgreSQL with zero downtimeDmitriy Pogibenko · РИТ++ 2017
• 32mPostgreSQL Major Upgrades: Swapping the Elephant Without Breaking the RoomAnton Borisov · ContainerDays Hamburg 2026
• 34mPartitioning and Data Migrations Using PostgreSQL as an ExampleDenis Ivanov · HighLoad++ 2014