Online PostgreSQL Column Type Migration
How to modify PostgreSQL column types online? A general approach
Tags: Migration
Changing Engines Mid-Flight — PostgreSQL Zero-Downtime Data Migration
Data migration typically involves stopping services for updates. Zero-downtime data migration is a relatively advanced operation.