Upgrading PXF When You Upgrade from a Previous LightDB-A Database 6.x Version

Step 1: PXF Pre-Upgrade Actions
Step 2: Registering or Upgrading PXF

Note: Starting in LightDB-A Database version 6.19.0, the PXF software is no longer bundled in the LightDB-A Server distribution. You may be required to download and install the PXF rpm or deb package to use PXF in your LightDB-A cluster as described in the procedures below.

If you are using PXF in your current LightDB-A Database 6.x installation, you must perform some PXF upgrade actions when you upgrade to a newer version of LightDB-A Database 6.x. This procedure uses PXF.from to refer to your currently-installed PXF version.

Note if you are planning to upgrade a PXF rpm or deb installation, refer to the PXF upgrade documentation.

The PXF upgrade procedure has two parts. You perform one procedure before, and one procedure after, you upgrade to a new version of LightDB-A Database:

Step 1: PXF Pre-Upgrade Actions
Upgrade to a new LightDB-A Database version
Step 2: Upgrading PXF

Step 1: PXF Pre-Upgrade Actions

Perform this procedure before you upgrade to a new version of LightDB-A Database:

Log in to the LightDB-A Database coordinator node. For example:
```
$ ssh gpadmin@<gpcoordinator>
```
Identify and note the PXF.from version number. For example:
```
gpadmin@gpcoordinator$ pxf version
```
Determine if PXF.from is a PXF rpm or deb installation (/usr/local/pxf-gp<greenplum-major-version>), or if you are running PXF.from from the LightDB-A Database server installation ($GPHOME/pxf), and note the answer.
If the PXF.from version is 5.x, identify the file system location of the $PXF_CONF setting in your PXF 5.x PXF installation; you might need this later. If you are unsure of the location, you can find the value in pxf-env-default.sh.
Stop PXF on each segment host as described in Stopping PXF.
Upgrade to the new version of LightDB-A Database and then continue your PXF upgrade with Step 2: Upgrading PXF.

Step 2: Registering or Upgrading PXF

After you upgrade to the new version of LightDB-A Database, perform the following procedure to configure the PXF software; you may be required to install the standalone PXF distribution:

Log in to the LightDB-A Database coordinator node. For example:
```
$ ssh gpadmin@<gpcoordinator>
```
If you previously installed the PXF rpm or deb on your LightDB-A 6.x hosts, you must register it to continue using PXF:
1. Copy the PXF extension files from the PXF installation directory to the new LightDB-A 6.x install directory:
```
gpadmin@gpcoordinator pxf cluster register
```
2. Start PXF on each segment host as described in Starting PXF.
3. Skip the following steps and exit this procedure.
Starting in LightDB-A Database version 6.19.0, PXF is removed from the LightDB-A Server distribution. You must download and install the standalone PXF rpm or deb package as described in Installing PXF. Install the same PXF 5.x version as PXF.from.
Synchronize the PXF configuration from the coordinator host to the standby coordinator and each LightDB-A Database segment host. For example:
```
gpadmin@gpcoordinator$ $GPHOME/pxf/bin/pxf cluster sync
```

Start PXF on each segment host:

gpadmin@gpcoordinator$ $GPHOME/pxf/bin/pxf cluster start

Your LightDB-A Database cluster is now running the same version of PXF, but running it from the PXF installation directory (/usr/local/pxf-gp<greenplum-major-version>). Should you wish to upgrade PXF in the future, consult the PXF upgrade documentation.