The PXF download package is an
.deb 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:
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
sudoprivileges, to remove the PXF package.
Follow these steps to remove PXF from your Greenplum Database cluster:
Log in to the Greenplum Database master node. For example:
$ ssh gpadmin@<gpmaster>
Stop PXF as described in Stopping PXF.
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*
Remove PXF from each Greenplum Database master, standby, and segment host. You must be an operating system superuser, or have
sudoprivileges, 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
On a CentOS/RHEL system:
gpadmin@gpmaster$ gpssh -e -v -f gphostfile "sudo rpm -e pxf-gp6"
On an Ubuntu system:
gpadmin@gpmaster$ gpssh -e -v -f gphostfile "sudo dpkg --remove pxf-gp6"
The command removes the PXF install files on all Greenplum hosts. The command also removes the PXF runtime directories on all hosts.
$PXF_CONFis not affected by this command and remains on the Greenplum hosts.