WarehousePG

Appearance

PXF commands

PXF provides two related commands. Run pxf <command> to act on the local host only, or pxf cluster <command> to run the same action across every host in the cluster over SSH, using the coordinator's PXF_HOME, PXF_BASE, and other environment variables. Use the pxf cluster form for routine cluster administration, covered in Managing the PXF cluster.

Cluster commands ​

Run these from the coordinator host.

pxf cluster prepare ​

Creates $PXF_BASE on every host and copies the default configuration templates from $PXF_HOME/conf into it. See Initializing and starting PXF for usage in context.

bash
pxf cluster prepare

pxf cluster register ​

Installs the PXF extension's control, SQL, and shared library files under $GPHOME on every host. Needed because make install only places these files under $GPHOME on the coordinator. See Installing on the cluster for usage in context.

bash
pxf cluster register

pxf cluster start ​

Starts the PXF service on every host. See Starting, stopping, and restarting PXF for usage in context.

bash
pxf cluster start

pxf cluster stop ​

Stops the PXF service on every host. See Starting, stopping, and restarting PXF for usage in context.

bash
pxf cluster stop

pxf cluster restart ​

Stops, then starts, the PXF service on every host. See Starting, stopping, and restarting PXF for usage in context.

bash
pxf cluster restart

pxf cluster status ​

Reports whether the PXF service is both running and responsive on every host. See Monitoring PXF for usage in context.

bash
pxf cluster status

pxf cluster sync ​

Copies $PXF_BASE/{conf,lib,servers} from the coordinator to every other host. See Applying a configuration change and Relocating $PXF_BASE for usage in context.

bash
pxf cluster sync [options]
OptionDescription
--deleteAlso remove files on the remote hosts that no longer exist on the coordinator.

Example:

bash
pxf cluster sync --delete

pxf cluster migrate ​

Migrates configuration from an older PXF installation into a new $PXF_BASE.

bash
pxf cluster migrate

pxf cluster init ​

(Deprecated) Installs the PXF extension under $GPHOME. Use pxf cluster register instead.

bash
pxf cluster init

pxf cluster reset ​

(Deprecated) No operation.

bash
pxf cluster reset

Local commands ​

Run these on a single host to act on that host's PXF instance only.

pxf prepare ​

Creates $PXF_BASE on the local host and copies the default configuration templates into it. Equivalent to pxf cluster prepare, scoped to this host.

bash
pxf prepare

pxf register ​

Installs the PXF extension under $GPHOME on the local host. Useful after a WHPG upgrade.

bash
pxf register

pxf start ​

Starts the local PXF service instance.

bash
pxf start

pxf stop ​

Stops the local PXF service instance.

bash
pxf stop

pxf restart ​

Restarts the local PXF service instance.

bash
pxf restart

pxf status ​

Reports whether the local PXF service instance is running.

bash
pxf status

pxf sync ​

Copies $PXF_BASE/{conf,lib,servers} from the local host to another host. Unlike pxf cluster sync, you specify the target host explicitly.

bash
pxf sync <hostname> [options]
OptionDescription
--deleteAlso remove files on <hostname> that no longer exist locally.

Example:

bash
pxf sync sdw3 --delete

pxf migrate ​

Migrates configuration from an older PXF installation into a new $PXF_BASE on the local host.

bash
pxf migrate

pxf version ​

Shows the PXF server version.

bash
pxf version

pxf init ​

(Deprecated) Installs the PXF extension under $GPHOME on the local host. Use pxf register instead.

bash
pxf init

pxf reset ​

(Deprecated) No operation.

bash
pxf reset