PXF is a Java service. It requires a Java 8 or Java 11 installation on each Greenplum Database host.


Ensure that you have access to, or superuser permissions to install, Java 8 or Java 11 on each Greenplum Database host.


Perform the following procedure to install Java on the master host, standby master host, and on each segment host in your Greenplum Database cluster. You will use the gpssh utility where possible to run a command on multiple hosts.

  1. Log in to your Greenplum Database master host:

    $ ssh gpadmin@<gpmaster>
  2. Determine the version(s) of Java installed on the system:

    gpadmin@gpmaster$ rpm -qa | grep java
  3. If the system does not include a Java version 8 or 11 installation, install one of these Java versions on the master host, standby master host, and on each Greenplum Database segment host.

    1. 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 gphostfile may include:

    2. Install the Java package on each host. For example, to install Java version 8:

      gpadmin@gpmaster$ gpssh -e -v -f gphostfile sudo yum -y install java-1.8.0-openjdk-1.8.0*
  4. Identify the Java 8 or 11 $JAVA_HOME setting for PXF. For example:

    If you installed Java 8:


    If you installed Java 11:


    If the superuser configures the newly-installed Java alternative as the system default:

  5. Note the $JAVA_HOME setting; you will need this value when you configure PXF.

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