Configuring the PXF Agent Host and Port (Optional)
A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 5.x documentation.
By default, a PXF agent started on a segment 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 agent listens for requests on the host. The default port number is
Set the environment variables in the
.bashrc shell login file on each segment host.
Perform the following procedure to configure the PXF agent host and/or port number on one or more Greenplum Database segment hosts:
Log in to your Greenplum Database master node:
$ ssh gpadmin@<gpmaster>
For each Greenplum Database segment host:
- Identify the host name or IP address of the PXF agent.
- Identify the port number on which you want the PXF agent to run.
Log in to the Greenplum Database segment host:
$ ssh gpadmin@<seghost>
~/.bashrcfile in the editor of your choice.
PXF_PORTenvironment variables. For example, to set the PXF agent 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.
Restart PXF on each Greenplum Database segment host as described in Restarting PXF.