The Greenplum Platform Extension Framework (PXF) for Greenplum Database 5.21.2+ and 6.x for CentOS 7.x and RHEL 7.x platforms is available from a separately-downloadable package on Pivotal Network.
The PXF download package is an
.rpm file that installs PXF libraries, executables, and script files on a Greenplum Database host.
When you install PXF, you will:
- Satisfy the prerequisites.
- Download the PXF package.
- Install the PXF
.rpmon every host in your Greenplum Database cluster.
- Check out Next Steps for post-install topics.
The recommended deployment model is to install PXF on all Greenplum Database hosts. Before you install PXF, ensure that you meet the following prerequisites:
- Greenplum version 5.21.2 or later or 6.x is installed in the cluster.
- You have access to all hosts (master, standby master, and segment hosts) in your Greenplum Database cluster.
- You must be an operating system superuser, or have
sudoprivileges, to install the PXF package. You can install the package in the default location
/usr/local/pxf-gp<greenplum-major-version>. Or, you can choose to install the package into a custom location by specifying the
--prefixoption to the install command.
- You have installed Java 8 or 11 on all Greenplum Database hosts as described in Installing Java for PXF.
- You can identify the operating system user that will own the PXF installation. This user must be the same user that owns the Greenplum Database installation, or a user that has write privileges to the Greenplum Database installation directory.
- If you have previously configured and are using PXF in your Greenplum installation:
- Identify and note the current PXF version number.
- Stop PXF as described in Stopping PXF.
$GPHOME/pxfdirectory exists in your Greenplum installation, you may choose to remove the directory on all Greenplum hosts after you confirm that you have installed and configured PXF correctly and that it is working as expected.
If you choose to remove this directory, you may encounter
warning: <pxf-filename>: remove failed: No such file or directory messages when you upgrade Greenplum. You can ignore these warnings for PXF files.
PXF is available as a separate download for Greenplum Database 5.x or 6.x for CentOS 7.x and RHEL 7.x platforms from Pivotal Network:
Download the package by navigating to Pivotal Network and locating and selecting the Release Download directory named Greenplum Platform Extension Framework.
The format of the PXF download filename is
pxf-gp<greenplum-major-version>-<pxf-version>-<pkg-version>.<platform>.<file_type>. For example:
Make note of the directory to which the file was downloaded.
You must install the PXF package on the Greenplum Database master and standby master hosts, and on each segment host.
If you installed an older version of the PXF package on your hosts, installing a newer package removes the existing PXF installation, and installs the new version.
The install procedure follows:
Locate the installer file that you downloaded from Pivotal Network.
Create a text file that lists your Greenplum Database standby master host and segment hosts, one host name per line. For example, a file named
gpmaster mstandby seghost1 seghost2 seghost3
Copy the PXF
.rpmfile to all hosts in your Greenplum cluster. For example, to copy the files to the
/tmpdirectory on each host:
gphost$ gpscp -f gphostfile pxf-gp6-5.15.0-2.el7.x86_64.rpm =:/tmp/
Install the package on each Greenplum Database host using your package management utility. If a previous installation of PXF exists for the same Greenplum version, the files and runtime directories from the older version are removed before the current package is installed.
To install PXF into the default location on all Greenplum hosts:
gphost$ gpssh -e -v -f gphostfile "sudo rpm -Uvh /tmp/pxf-gp6-5.15.0-2.el7.x86_64.rpm"
When you install the PXF
.rpmpackage to the default location, PXF is installed to
To install PXF into a custom location on all Greenplum hosts:
gpadmin@gphost$ gpssh -e -v -f gphostfile "sudo rpm -Uvh --prefix <install-location> pxf-gp6-5.15.0-2.el7.x86_64.rpm"
Set the ownership and permissions of the PXF installation files to enable access by the
gpadminuser. For example, if you installed PXF to the default location:
gphost$ gpssh -e -v -f gphostfile "sudo chown -R gpadmin:gpadmin /usr/local/pxf-gp*"
If you installed PXF to a custom
<install-location>, specify that location in the command.
(Optional) Add the PXF
bindirectory to the PXF owner’s
$PATH. For example, if you installed PXF for Greenplum 6 in the default location, you could add the following text to the
.bashrcshell initialization script for the
Be sure to remove any previously-added
$PATHentries for PXF in
Remove the PXF
.rpmfile that you copied to each system. For example, to remove the file from
gpadmin@gphost$ gpssh -e -v -f gphostfile "rm -f /tmp/pxf-gp6-5.15.0-2.el7.x86_64.rpm"
PXF is not active after installation. You must explicitly initialize and start the PXF server before you can use PXF.
- See About the PXF Installation and Configuration Directories for a list and description of important PXF files and directories.
- If this is your first time using PXF, review Configuring PXF for a description of the initialization and configuration procedures that you must perform before you can use PXF.
- If you installed the PXF
.rpmas part of a Greenplum Database upgrade procedure, return to those upgrade instructions.
- If you installed the PXF
.rpminto a Greenplum cluster in which you had already configured and were using PXF, you may be required to perform some upgrade actions. Recall the original version of PXF (before you installed the
.rpm), and perform Step 2 of the PXF upgrade procedure.