Question
Minor versus major PostgreSQL upgrades: what changes, and when is each approach used?
Answer
Minor upgrades replace executables with the server stopped; the data directory remains compatible. Major upgrades can require data migration because storage and system catalogs change. Patch within a major release; plan pg_upgrade, logical replication, or dump/restore for a major release.