When you have completed upgrading to the new Greenplum Database version, you can stop the gpupgrade hub and agent processes, and then perform these additional steps:

  1. Merge any user-defined parameters and modifications from the source cluster configuration files such as pg_hba.conf postgresql.conf into the target cluster configuration files. Be mindful of deprecated parameters.

  2. Copy any user-defined files from the source cluster to the target clusters data directory.

  3. Perform any post-upgrade tasks required by supported extensions, as summarized in the following table:

    Extension Post Upgrade Task(s)
    PostGIS Run the following scripts in each database where PostGIS is installed: $GPHOME_TARGET/share/postgresql/contrib/postgis-2.1/postgis_replace_views.sql and $GPHOME_TARGET/share/postgresql/contrib/postgis-2.1/postgis_enable_operators.sql.
    PXF Perform the PXF Post-gpupgrade Actions procedure.
    Greenplum Command Center See the Command Center Post-Upgrade Steps.
  4. Once the new cluster is fully operational and verified, remove the source cluster with the following command:

    $ gpssh -f <hostfile> -d "rm -rf <data-directory-name>_old"
check-circle-line exclamation-circle-line close-line
Scroll to top icon