Unsupported extensions must be uninstalled from the source cluster before the upgrade process and reinstalled after the upgrade is complete.
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.
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
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.
|Oracle Compatibility Functions||DROP EXTENSION|
|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|
Greenplum Command Center is not supported with
gpupgrade. Follow these steps to uninstall Command Center from the source cluster and then reinstall after upgrading.
Before you begin the initialize phase, perform these steps on the source cluster to uninstall Greenplum Command Center:
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;
$MASTER_DATA_DIRECTORY/gpmetricsdirectory to a safe location.
After the upgrade process completes, perform these steps on the target cluster to install Greenplum Command Center:
$MASTER_DATA_DIRECTORY/gpmetricsdirectory using the backup that you created from the source cluster prior to upgrading.