By default, a PXF Service started on a Greenplum 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 Service 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 Greenplum host.

Note: You must restart both Greenplum Database and PXF when you configure the service host and/or port in this manner. Consider performing this configuration during a scheduled down time.


Perform the following procedure to configure the PXF Service host and/or port number on one or more Greenplum Database hosts:

  1. Log in to your Greenplum Database master host:

    $ ssh gpadmin@<gpmaster>
  2. For each Greenplum Database host:

    1. Identify the host name or IP address of the PXF Service.
    2. Identify the port number on which you want the PXF Service to run.
    3. Log in to the Greenplum Database host:

      $ ssh gpadmin@<seghost>
    4. Open the ~/.bashrc file in the editor of your choice.
    5. Set the PXF_HOST and/or PXF_PORT environment variables. For example, to set the PXF Service port number to 5998, add the following to the .bashrc file:

      export PXF_PORT=5998
    6. Save the file and exit the editor.
  3. Restart Greenplum Database as described in Restarting Greenplum Database in the Greenplum Documentation.

  4. Restart PXF on each Greenplum Database host as described in Restarting PXF.

  5. 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.

check-circle-line exclamation-circle-line close-line
Scroll to top icon