PXF is compatible with these operating system platforms:

OS Version PXF Version
RHEL 8.x 6.3+ for Greenplum 6.20+
RHEL 8.x 6.8+ for Greenplum 7.x
RHEL 9.x 6.9+ for Greenplum 6.26+

If you plan to upgrade the operating system in your Greenplum Database cluster hosts to a new OS and you are running PXF in your Greenplum installation, please refer to the above table to determine which version of PXF is required. You must perform some PXF-specific actions before and after you upgrade the OS.

The following procedures assume that you are upgrading the OS on a different set of hosts than that of the current/running Greenplum cluster.

Pre-OS Upgrade Actions

Perform the following steps before you upgrade the operating system:

  1. Upgrade PXF in your current cluster to at least the version of PXF listed in the table above and verify PXF operation before you commence the OS upgrade. For example, if you want to upgrade your Greenplum 6 cluster to RHEL 8, upgrade to PXF v6.3+.

  2. Retain the following PXF user configuration directories, typically located in /usr/local/pxf-gp6: conf/, keytabs/, lib/, and servers/. If you relocated $PXF_BASE, retain the configuration in that directory.

Post-OS Upgrade Actions

After you upgrade the operating system and install, configure, and verify Greenplum Database on the new set of hosts, perform the following procedure:

  1. Download a PXF package for the upgraded OS from Broadcom Support Portal. You must download the same version of PXF as the version that was running on the original Greenplum Database cluster.

    Note

    For more information about download prerequisites, troubleshooting, and instructions, see Download Broadcom products and software.

  2. Install PXF for the upgraded OS on all Greenplum Database hosts.

  3. Copy the PXF configuration files from the original cluster to /user/local/pxf-gp6 on the upgraded OS Greenplum Database coordinator host. If you choose to relocate $PXF_BASE, copy the configuration to that directory instead.

  4. Synchronize the PXF configuration to all hosts in the Greenplum cluster:

    gpadmin@coordinator$ pxf cluster sync

  5. Start PXF on each Greenplum host:

    gpadmin@coordinator$ pxf cluster start

  6. Verify that PXF can access each external data source by querying external tables that specify each PXF server configuration.

check-circle-line exclamation-circle-line close-line
Scroll to top icon