The VMware Tanzu Greenplum Platform Extension Framework download package is an
.deb file that installs 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:
pxfprotocol. You can remove them manually, or you can provide the
CASCADEkeyword when you unregister PXF as described in the next step.
Before you uninstall PXF, ensure that you meet the following prerequisites:
pxfexternal tables and to drop the
pxfextension in affected databases.
sudoprivileges, to remove the 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 the Service.
Remove the 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 the package 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 package on all hosts listed in
On a CentOS/RHEL 7.x or 8.x 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 install files on all Greenplum hosts. The command also removes the runtime directories on all hosts.
$PXF_BASEare not affected by this command and remain on the Greenplum hosts.