Perform the Post-Upgrade Actions

Perform the following steps once VMware Tanzu Greenplum upgrade has completed upgrading Greenplum Database in order to ensure consistency across your environment.

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 Tanzu Greenplum command center	See the GPCC Post-Upgrade Steps below

   GPCC Post-Upgrade Steps

   Perform the following steps on the target cluster to install Tanzu Greenplum command center:

   • Install the latest version of Tanzu 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.
   • Run the following commands:

     BEGIN;
     LOCK TABLE gpmetrics._gpcc_pg_log_meta IN EXCLUSIVE MODE;
     TRUNCATE gpmetrics._gpcc_pg_log_meta;
     INSERT INTO gpmetrics._gpcc_pg_log_meta (id, last_log_file, last_offset) SELECT 1, last_log_file, last_offset 
     FROM gpmetrics._gpcc_pg_log_last_file ORDER BY last_log_file DESC LIMIT 1;
     COMMIT; 
     

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

6. If you decided not to run ANALYZE against the target cluster when you ran gpupgrade finalize, run vacuumdb all -analyze-in-stages now to update all table statistics. Be sure to account for the additional downtime required to recreate statistics on the cluster. You may use the option --table to specify individual tables in order to make more important tables available first.

7. Run VACUUM against your heap tables to generate free space maps, in order to improve data loading workloads on heap tables. You may perform this operation at any time, as concurrent VACUUM operations do not prevent reading or inserting data into heap tables.

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