gpcopy utility generates error: pq: unknown authentication response

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:
When using gpcopy to migrate data between clusters, the following error message is produced.  

gpcopy utility is giving error: pq: unknown authentication response: 7 

Environment

Cause

The causes of this issue is a missing entry in the destination host pg_hba.conf needed for the source_host to connect or vice versa.

Resolution

Check pg_hba.conf file on both the dest_host and source_host for any missing entries that are needed to allow connections between the two servers, and add the missing entry.