Install gpcopy on standby coordinator

Products

• VMware Tanzu Data Suite
• Greenplum
• VMware Tanzu Greenplum

Issue/Introduction

Tanzu Greenplum Data Copy Utility documentation lacks steps for gpcopy install on the standby coordinator.

Resolution

To install gpcopy on your standby coordinator, copy the files from the coordinator to the standby coordinator.

• Use the gpscp utility on the coordinator to install both gpcopy and gpcopy_helper to the standby coordinator. The command that you specify differs based on the Greenplum Database version. For example:

If your source Greenplum cluster is running version 5.x or 6.x:

gpscp -h <standby host> gpcopy =:/usr/local/greenplum-db-<version>/bin
gpscp -h <standby host> gpcopy_helper =:/usr/local/greenplum-db-<version>/bin

If your source Greenplum cluster is running version 7.x:

gpsync -h <standby host> gpcopy =:/usr/local/greenplum-db-<version>/bin
gpsync -h <standby host> gpcopy_helper =:/usr/local/greenplum-db-<version>/bin

 

• Set read and execute permissions on the gpcopy_helper file for the gpadmin user on the standby coordinator. For example:

gpssh -h <standby host> -e 'chmod 755 /usr/local/greenplum-db-<version>/bin/gpcopy'
gpssh -h <standby host> -e 'chmod 755 /usr/local/greenplum-db-<version>/bin/gpcopy_helper'