By default, a PXF Service started on a Greenplum host listens on port number
localhost. You can configure PXF to start on a different port number, or use a different hostname or IP address. To change the default configuration, you will set one or both of the environment variables identified below:
|PXF_HOST||The name of the host or IP address. The default host name is
|PXF_PORT||The port number on which the PXF Service listens for requests on the host. The default port number is
Set the environment variables in the
.bashrc shell login file on each Greenplum host.
Perform the following procedure to configure the PXF Service host and/or port number on one or more Greenplum Database hosts:
Log in to your Greenplum Database master host:
$ ssh gpadmin@<gpmaster>
For each Greenplum Database host:
Log in to the Greenplum Database host:
$ ssh gpadmin@<seghost>
~/.bashrcfile in the editor of your choice.
PXF_PORT environment variables. For example, to set the PXF Service port number to 5998, add the following to the
Restart Greenplum Database as described in Restarting Greenplum Database in the Greenplum Documentation.
Restart PXF on each Greenplum Database host as described in Restarting PXF.
Verify that PXF is running on the reconfigured host and/or port by invoking
http://<PXF_HOST>:<PXF_PORT>/actuator/health to view PXF monitoring information as described in About PXF Service Runtime Monitoring.