Installing Java for PXF
A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 5.x documentation.
PXF is a Java service. It requires a Java 8 or Java 11 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 8 or Java 11 on each Greenplum Database host.
Perform the following procedure to install Java on the master, standby 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.
Log in to your Greenplum Database master node:
$ ssh gpadmin@<gpmaster>
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
mstandby seghost1 seghost2 seghost3
Install Java on the master, standby master, and on each Greenplum Database segment host, and then set up the Java environment on each host.
Install the Java package. For example, to install Java version 8:
gpadmin@gpmaster$ sudo yum -y install java-1.8.0-openjdk-1.8.0* gpadmin@gpmaster$ gpssh -e -v -f gphostfile sudo yum -y install java-1.8.0-openjdk-1.8.0*
Identify the Java base install directory. Update the
.bashrcfile on each host to include this
$JAVA_HOMEsetting if it is not already present. For example, if you installed Java 8:
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 gphostfile "echo 'export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.x86_64/jre' >> /home/gpadmin/.bashrc"
If you installed Java 11,
Note: If the superuser selected the newly-installed Java alternative as the system default,