PXF - "create extension pxf" results in ERROR: could not open extension control file "pxf.control": No such file or directory

Products

• VMware Tanzu Greenplum

Issue/Introduction

Following PXF installation instructions (version 6.8.0), there is a missing file even though pxf cluster register reports success.

$ pxf -v 
PXF version 6.8.0

$ pxf cluster register
Installing PXF extension on coordinator host and 2 segment hosts...
PXF extension has been installed on 3 out of 3 hosts

$ psql
psql (9.4.26)
Type "help" for help.

gpadmin=# create extension pxf;
ERROR:  could not open extension control file "/usr/local/6.25.3/greenplum-db-6.25.3/share/postgresql/extension/pxf.control": No such file or directory

Environment

Product Version: 6.19

Resolution

Check the permissions of "/usr/local/6.25.3/greenplum-db-6.25.3/share/postgresql/extension/" directory. In this case permissions did not allow pxf to install control file, even though there were no errors displayed.

Changing the permissions of the directory to allow installer to write into the directory allowed "pxf cluster register" to place the file into the directory.