Perform the Post-Upgrade Actions

When you have completed upgrading to the new Greenplum Database version, perform these additional steps:

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

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

3. Perform the following post-upgrade tasks required by supported extensions, if applicable:

   Extension	Post Upgrade Task(s)
   PXF	Perform the PXF Post-gpupgrade Actions procedure.

4. Re-install any unsupported extensions you uninstalled when preparing for the upgrade:

   Extension	Installing
   Oracle Compatibility Functions	Installing Oracle Compatibility Functions
   Greenplum PL/Java Language Extension	Installing PL/Java
   Python Data Science Module Package	Installing the Python Data Science Module Package
   R Data Science Library Package	Installing the R Data Science Library Package
   VMware Greenplum Command Center	See the GPCC Post-Upgrade Steps below

   GPCC Post-Upgrade Steps

   Perform the following steps on the target cluster to install Greenplum Command Center:

   • Install the latest version of Greenplum Command Center 6.
   • If the Command Center installer prompts you to upgrade the metrics_collector, follow the provided instructions.
   • Restore the $MASTER_DATA_DIRECTORY/gpmetrics directory using the backup that you created from the source cluster prior to upgrading.

5. If you applied any of the workarounds suggested during the pg_upgrade Checks, complete any actions that are pending upgrade completion.

6. Run ANALYZE to restore cluster statistics. Be sure to account for the additional downtime required to recreate statistics on the cluster.

7. 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"