Installing Java for PXF

PXF is a Java service. It requires a Java 1.8 installation on each Greenplum Database host.

If an appropriate version of Java is already installed on each Greenplum Database host, you need not perform the procedure in this topic.


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


Perform the following procedure to install Java on the master 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 node:

    $ ssh gpadmin@<gpmaster>
  2. Create a text file that lists your Greenplum Database segment hosts, one host name per line. For example, a file named seghostfile may include:

  3. Install Java on the master and on each Greenplum Database segment host, and then set up the Java environment on each host.

    1. Install the Java package. For example, to install Java version 1.8:

      gpadmin@gpmaster$ sudo yum -y install java-1.8.0-openjdk-1.8.0*
      gpadmin@gpmaster$ gpssh -e -v -f seghostfile sudo yum -y install java-1.8.0-openjdk-1.8.0*
    2. Identify the Java base install directory. Update the gpadmin user’s .bashrc file on each segment host to include this $JAVA_HOME setting if it is not already present. For example:

      gpadmin@gpmaster$ echo 'export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.x86_64/jre' >> /home/gpadmin/.bashrc
      gpadmin@gpmaster$ gpssh -e -v -f seghostfile "echo 'export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.x86_64/jre' >> /home/gpadmin/.bashrc"