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

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

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

• Step 1: PXF Pre-Upgrade Actions
• Upgrade to a new WarehousePG version
• Step 2: Upgrading PXF

Step 1: PXF Pre-Upgrade Actions

Perform this procedure before you upgrade to a new version of WarehousePG:

1. Log in to the WarehousePG coordinator node. For example:

   $ ssh gpadmin@<gpmaster>

2. Identify and note the PXF.from version number. For example:

   gpadmin@gpmaster$ pxf version

3. 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 WarehousePG server installation ($GPHOME/pxf), and note the answer.

4. 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.

5. Stop PXF on each segment host.

6. Upgrade to the new version of WarehousePG 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 WarehousePG, perform the following procedure to configure the PXF software; you may be required to install the standalone PXF distribution:

1. Log in to the WarehousePG coordinator node. For example:

   $ ssh gpadmin@<gpmaster>

2. If you previously installed the PXF rpm or deb on your WarehousePG 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 WarehousePG 6.x install directory:

      gpadmin@gpmaster pxf cluster register

   2. Start PXF on each segment host.

   3. Skip the following steps and exit this procedure.

3. Starting in WarehousePG version 6.19.0, PXF is removed from the WarehousePG Server distribution. You must download and install the standalone PXF rpm or deb package. Install the same PXF 5.x version as PXF.from.

4. Synchronize the PXF configuration from the coordinator host to the standby coordinator and each WarehousePG segment host. For example:

   gpadmin@gpmaster$ $GPHOME/pxf/bin/pxf cluster sync

5. Start PXF on each segment host:

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

Your WarehousePG 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.