Major upgrade of Greengage using pg_upgrade and ggupgrade

▤ Summary

This article explains how to upgrade Greengage, the open-source Greenplum-based database, from version 6 to version 7 using pg_upgrade and the ggupgrade wrapper. It walks through the upgrade flow for both dispatcher and segment nodes, including consistency checks, data file handling, and post-upgrade recovery steps. The guide also covers practical issues such as path setup, Ubuntu 22.04 adjustments, and switching between link and copy modes. The final section introduces ggupgrade as a simpler orchestrated process that bundles initialize, execute, and finalize steps around pg_upgrade.

▦ Linked Companies