How to perform a minor version downgrade of Platform Extension Framework 6.x in Tanzu Greenplum

Products

• VMware Tanzu Greenplum

Issue/Introduction

This article covers how to perform a minor version downgrade for Platform Extension Framework (PXF) 6.x.

If you are trying to perform a major version downgrade of PFX, refer to How to perform a major version downgrade Platform Extension Framework in Tanzu Greenplum.

Environment

Product Version: 6.18

Resolution

In this example we will downgrade from PXF v6.2 to v6.1 on GPDB 6. This also applies to PXF 6.x on Greenplum Database (GPDB) 5:

1. Download PXF 6.1.0 RPM from Tanzu Network. Make sure you download the right PXF file for your GPDB major version.

2. Copy the PXF 6.1.0 RPM to all GPDB host. This step can be done with the following gpscp command, where the all-hosts file contains the hostname for all nodes in GPDB cluster:

gpscp -f all-hosts -v pxf-gp6-6.1.0-2.el7.x86_64.rpm =:/tmp/pxf-gp6-6.1.0-2.el7.x86_64.rpm

3. Stop PXF cluster with this command:

pxf cluster stop

4. Install the PXF 6.1.0 RPM on all hosts. This step can be done with the following gpssh command and assumes that PXF 6.2.0 is already installed on the hosts.

gpssh -f all-hosts -u gpadmin -v -e 'sudo yum downgrade -y /tmp/pxf-gp6-6.1.0-2.el7.x86_64.rpm'

Note: If PXF 6.2.0 is not already installed on the hosts, the previous command should be replaced with:

gpssh -f all-hosts -u gpadmin -v -e 'sudo yum install -y /home/gpadmin/pxf-gp6-6.1.0-2.el7.x86_64.rpm'

5. Change the ownership and permissions of the PXF installation files.

gpssh -f all-hosts -u gpadmin -v -e 'sudo chown -R gpadmin:gpadmin /usr/local/pxf-gp6'

6. Start PXF with this command:

 pxf cluster start