PXF Service Host and Port
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 node:
$ ssh gpadmin@<gpmaster>
For each Greenplum Database host:
- Identify the host name or IP address of the PXF Service.
- Identify the port number on which you want the PXF Service to run.
Log in to the Greenplum Database host:
$ ssh gpadmin@<seghost>
~/.bashrcfile in the editor of your choice.
PXF_PORTenvironment variables. For example, to set the PXF Service port number to 5998, add the following to the
Save the file and exit the editor.
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.