PostgreSQL DBA

Upgrade, Patching & Migration

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.

This is 13 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples