Open search page
Hello, I’m DocuDroid!
Open Ask AI page
Submitting feedback
Thank you for rating our AI Search!
We would be grateful if you could share your thoughts so we can improve our AI Search for you and other readers.
GitHub

Manage PXF

Anton Monakov

You can start, stop, or restart PXF services either collectively, on all Greengage DB cluster hosts, or individually on each host. Use one of the following commands:

  • pxf cluster — manage all PXF service instances in the Greengage DB cluster.

  • pxf — manage the PXF service instance on a specific Greengage DB host.

NOTE

For the detailed description of all available PXF commands, see Overview of the pxf commands and Overview of the pxf cluster commands

Before running the commands, make sure the following prerequisites are met:

  • The PXF installation steps are performed as described in Installation. Specifically, make sure that the pxf executable location is added to PATH.

  • The Greengage DB cluster is up and running.

  • You are connected to the Greengage DB master host as gpadmin, for example:

    $ ssh gpadmin@mdw

Start PXF

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

$ pxf cluster start

Once started, the PXF service runs under the gpadmin user on the default port 5888.

Stop PXF

If you need to stop PXF, for example, when upgrading it, you must stop it on all hosts in the Greengage DB cluster.

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

$ pxf cluster stop

Restart PXF

If you need to restart PXF, for example, after updating the user configuration files, you run the pxf cluster restart command to stop and then start PXF on all hosts in the Greengage DB cluster.

Run the pxf cluster restart command to restart PXF on each host:

$ pxf cluster restart

Reload PXF configuration

If you modify a PXF profile or a server configuration, you can apply the changes and clean up the affected connection pools by running the pxf cluster reload command, without the need to restart PXF. Reloading a configuration terminates all active queries that are using it.

Run the pxf cluster reload command to reload PXF configuration on each host:

$ pxf cluster reload

The command accepts the following options:

  • -p, --profile — the name of the profile to reload thus terminating all active queries using it. The specified profile is reloaded either on the server specified in --server, or, if --server is not specified, on all servers.

  • -s, --server — the name of the server configuration the profile should be reloaded on. The --profile option is mandatory if --server is specified.

  • -a, --auto — if set, the reload action proceeds without user confirmation.

  • -h, --help — displays the help information about pxf cluster reload.

NOTE

If neither --profile nor --server are specified, all PXF profiles are reloaded on all servers.

Previous
Installation
Next
Grant user access to PXF