Starting, Stopping, and Restarting PXF

PXF provides two management commands:

pxf cluster - manage all PXF Service instances in the Greenplum Database cluster
pxf - manage the PXF Service instance on a specific Greenplum Database 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 Greenplum Database 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 Greenplum Database cluster, ensure that:

Your Greenplum Database cluster is up and running.
You have previously configured PXF.

Procedure

Perform the following procedure to start PXF on each host in your Greenplum Database cluster.

Log in to the Greenplum Database coordinator host:
```
$ ssh gpadmin@<coordinator>
```
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 Greenplum Database cluster. Only the gpadmin user can stop the PXF Service.

Prerequisites

Before you stop PXF in your Greenplum Database cluster, ensure that your Greenplum Database cluster is up and running.

Procedure

Perform the following procedure to stop PXF on each host in your Greenplum Database cluster.

Log in to the Greenplum Database coordinator host:
```
$ ssh gpadmin@<coordinator>
```
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 Greenplum Database cluster.

Only the gpadmin user can restart the PXF Service.

Prerequisites

Before you restart PXF in your Greenplum Database cluster, ensure that your Greenplum Database cluster is up and running.

Procedure

Perform the following procedure to restart PXF in your Greenplum Database cluster.

Restart PXF:

gpadmin@coordinator$ pxf cluster restart