Uninstalling PXF

The PXF download package is an .rpm file that installs PXF libraries, executables, and script files on a Greenplum Database host.

If you want to remove PXF from the Greenplum cluster and from your hosts, you will:

  1. Satisfy the prerequisites.
  2. Uninstall PXF from every host in your Greenplum Database cluster.

Prerequisites

Before you uninstall PXF, ensure that you meet the following prerequisites:

  • You have access to all hosts (master, standby master, and segment hosts) in your Greenplum Database cluster.
  • You must be an operating system superuser, or have sudo privileges, to remove the PXF package.

Uninstalling PXF

Follow these steps to remove PXF from your Greenplum Database cluster:

  1. Log in to the Greenplum Database master node. For example:

    $ ssh gpadmin@<gpmaster>
    
  2. Stop PXF as described in Stopping PXF.

  3. Remove the PXF library and extension files from your Greenplum installation:

    gpadmin@gpmaster$ rm $GPHOME/lib/postgresql/pxf.so
    gpadmin@gpmaster$ rm $GPHOME/share/postgresql/extension/pxf*
    
  4. Remove PXF from each Greenplum Database master, standby, and segment host. You must be an operating system superuser, or have sudo privileges, to remove the package. For example, if you installed PXF for Greenplum 6 in the default location on a CentOS 7 system, the following command removes the PXF package on all hosts listed in gphostfile:

    gpadmin@gpmaster$ gpssh -e -v -f gphostfile "sudo rpm -e pxf-gp6"
    

    The command removes the PXF files installed by the .rpm package on all Greenplum hosts. The command also removes the PXF runtime directories on all hosts.

The PXF configuration directory $PXF_CONF is not affected by this command and remains on the Greenplum hosts.