Configuring the PXF Agent Host and Port (Optional)
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
By default, a PXF agent started on a segment host listens on port number 5888
on 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:
Environment Variable | Description |
---|---|
PXF_HOST | The name of the host or IP address. The default host name is localhost . |
PXF_PORT | The port number on which the PXF agent listens for requests on the host. The default port number is 5888 . |
Set the environment variables in the gpadmin
user’s .bashrc
shell login file on each segment host.
Procedure
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>
Open the
~/.bashrc
file in the editor of your choice.Set the
PXF_HOST
and/orPXF_PORT
environment variables. For example, to set the PXF agent port number to 5998, add the following to the.bashrc
file:export PXF_PORT=5998
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.