Starting, Stopping, and Restarting PXF

PXF provides two management commands:

• pxf cluster - manage all PXF Service instances in the Apache Cloudberry cluster
• pxf - manage the PXF Service instance on a specific Apache Cloudberry host

Note: The procedures in this topic assume that you have added the <PXF_INSTALL_DIR>/bin directory to your $PATH.

Starting PXF

After configuring PXF, you must start PXF on each host in your Apache Cloudberry cluster. The PXF Service, once started, runs as the gpadmin user on default port 5888. Only the gpadmin user can start and stop the PXF Service.

If you want to change the default PXF configuration, you must update the configuration before you start PXF, or restart PXF if it is already running. See About the PXF Configuration Files for information about the user-customizable PXF configuration properties and the configuration update procedure.

Prerequisites

Before you start PXF in your Apache Cloudberry cluster, ensure that:

• Your Apache Cloudberry cluster is up and running.
• You have previously configured PXF.

Procedure

Perform the following procedure to start PXF on each host in your Apache Cloudberry cluster.

1. Log in to the Apache Cloudberry coordinator host:

   $ ssh gpadmin@<coordinator>

2. Run the pxf cluster start command to start PXF on each host:

   gpadmin@coordinator$ pxf cluster start

Stopping PXF

If you must stop PXF, for example if you are upgrading PXF, you must stop PXF on each host in your Apache Cloudberry cluster. Only the gpadmin user can stop the PXF Service.

Prerequisites

Before you stop PXF in your Apache Cloudberry cluster, ensure that your Apache Cloudberry cluster is up and running.

Procedure

Perform the following procedure to stop PXF on each host in your Apache Cloudberry cluster.

1. Log in to the Apache Cloudberry coordinator host:

   $ ssh gpadmin@<coordinator>

2. Run the pxf cluster stop command to stop PXF on each host:

   gpadmin@coordinator$ pxf cluster stop

Restarting PXF

If you must restart PXF, for example if you updated PXF user configuration files in $PXF_BASE/conf, you run pxf cluster restart to stop, and then start, PXF on all hosts in your Apache Cloudberry cluster.

Only the gpadmin user can restart the PXF Service.

Prerequisites

Before you restart PXF in your Apache Cloudberry cluster, ensure that your Apache Cloudberry cluster is up and running.

Procedure

Perform the following procedure to restart PXF in your Apache Cloudberry cluster.

1. Log in to the Apache Cloudberry coordinator host:

   $ ssh gpadmin@<coordinator>

2. Restart PXF:

   gpadmin@coordinator$ pxf cluster restart