The Greenplum Database gpupgrade
utility allows in-place upgrades from a major Greenplum Database 5.x version to a later 6.x major release. The cluster architecture and node count remain the same between version 5.x and 6.x. The upgrade does not require the time-consuming backup and restore typically used for major version upgrades. The gpupgrade utility removes the need for additional hardware and upgrade time through in-place upgrades.
gpupgrade
is not used for Greenplum minor version upgrades (for example from 6.9 to 6.10), because minor version upgrades do not change system tables and require only a software update.
Greenplum Upgrade includes several key features:
pg_upgrade and upstream workflow compatibility: Greenplum Upgrade is based on PostgreSQL
pg_upgrade
which removes the need for specific or unique logic. It is also compatible with upstream workflow.Crash-only” Idempotence: If an error occurs during upgrade, it is possible to address it and simply re-run upgrade.
Data migration scripts: Greenplum Upgrade generates scripts to modify certain objects that
pg_upgrade
cannot upgrade.Step-By-Step Workflow: The user interface walks you through step-by-step providing next actions to perform, along with suggestions for when errors occur.
Revert option: You can revert the environment during the upgrade process to its initial state.