The VMware Greenplum Platform Extension Framework download package is an .rpm
or .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:
- Satisfy the prerequisites.
- Remove all external tables that you created that specify the
pxf
protocol. You can remove them manually, or you can provide theCASCADE
keyword when you unregister PXF as described in the next step. - Unregister PXF from all databases in which you registered the
pxf
extension. - Uninstall PXF from every host in your Greenplum Database cluster.
Prerequisites
Before you uninstall PXF, ensure that you meet the following prerequisites:
- You have the Greenplum Database permissions required to remove
pxf
external tables and to drop thepxf
extension in affected databases. - 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 package.
Uninstalling 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 ingphostfile
: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_BASE
are not affected by this command and remain on the Greenplum hosts.
Content feedback and comments