How to add existing PXF to a new Standby Master in Greenplum

Products

• VMware Tanzu Greenplum

Issue/Introduction

Assume you have initialized PXF, but did not have a standby master configured at the time. Now when initializing the standby master, the $PXF_CONF files are not copied over.

What is the best way to transfer the existing config over to the standby master without having to reinitialize PXF?

Environment

Product Version: 6.1

Resolution

After you create your standby master:

1. ssh into standby master host and set MASTER_DATA_DIRECTORY and GPHOME.

2. Run PXF_CONF=/usr/local/greenplum-pxf $GPHOME/pxf/bin/pxf init. The PXF_CONF needs to be the same directory as in the current master.

3. On current master, run following command: 

pxf cluster sync

This will add PXF to your standby master. You can confirm this by running: pxf cluster status.

Note: This also applies to PXF installs on Greenplum 5.x.