Unsupported extensions must be uninstalled from the source cluster before the upgrade process, and reinstalled after the upgrade is complete.

Unsupported Extensions

Generally, to upgrade unsupported extensions manually you must uninstall them from the source cluster before running gpupgrade and then reinstall them on the target cluster once upgrading is complete. For a list of common unsupported extensions and links to instructions for uninstalling them, see Uninstall Unsupported Extensions, below.

Greenplum Command Center is an unsupported extension that requires more complex steps for manually upgrading than simply uninstalling and reinstalling. See Upgrading Greenplum Command Center for instructions on upgrading Command Center.

Uninstalling Unsupported Extensions

WARNING: Dropping any extension that defines user defined types, aggregates, functions, operators, or views, will drop the data associated with those objects.
For example, if an extension declares a user defined type, any tables and columns that use that type will be dropped when the extension is dropped. One specific example is the PostGIS extension that defines a geometry data type. A column that uses the geometry type will be dropped when PostGIS is dropped.

When you have completed the upgrade you can reinstall the extensions in the target Greenplum system. For extensions or packages that are not included in the Greenplum Database distribution, download and install the correct version for the target Greenplum Database system.

Drop or alter any tables, views, or UDFs you have created that reference UDFs or custom data types supplied by extensions. Remove any files the extension creates in the Greenplum Database master data directory.

Keep track of the extensions you uninstall, and the related modifications you had to make to the source Greenplum Database system, so that you can re-apply them after gpupgrade finalize.

The following table lists common unsupported extensions with links to instructions to uninstall them. Some extensions can be uninstalled using the gppkg package utility, others are uninstalled by running scripts.

Extension Uninstalling
Oracle Compatibility Functions Oracle Compatibility Functions
VMware Tanzu Greenplum Command Center Upgrading Greenplum Command Center
Greenplum PL/Java Language Extension Uninstalling PL/Java
Python Data Science Module Package Uninstalling the Python Data Science Module Package
R Data Science Library Package Uninstalling the R Data Science Library Package

Upgrading Greenplum Command Center

Greenplum Command Center is not supported with gpupgrade. Follow these steps to uninstall Command Center from the source cluster and then reinstall after upgrading.

Pre-Upgrade Steps

Before you begin the initialize phase, perform these steps on the source cluster to uninstall Greenplum Command Center:

  1. Upgrade to the latest version of Greenplum Command Center 4.X.
  2. Access the “Workload Mgmt” page from Command Center to ensure all previous settings have been migrated.
  3. Stop Command Center by issuing the gpcc stop command.
  4. Issue the the following commands against Greenplum Database:
    drop external web table gpmetrics.gpcc_size_ext_table from gpperfmon;
    drop view gpmetrics.gp_data_dirs from gpperfmon;
    drop extension gp_wlm from postgres;
    
  5. Back up the contents of the $MASTER_DATA_DIRECTORY/gpmetrics directory to a safe location.

Post-Upgrade Steps

After the upgrade process completes, perform these steps on the target cluster to install Greenplum Command Center:

  1. Install the latest version of Greenplum Command Center 6.
  2. If the Command Center installer prompts you to upgrade the metrics_collector, follow the provided instructions.
  3. Restore the $MASTER_DATA_DIRECTORY/gpmetrics directory using the backup that you created from the source cluster prior to upgrading.
check-circle-line exclamation-circle-line close-line
Scroll to top icon