gpload unable to import the PyGreSQL Python module (pg.py)

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

Installing gpload on a new system produces an error saying python modules are missing.

Error Message:

gpload.py -v 
gpload was unable to import The PyGreSQL Python module (pg.py) - No module named pygresql

Environment

Cause

The greenplum_loader_path.sh has not been sourced correctly.

Resolution

1. Find the greenplum_loader_path.sh.

find / -name greenplum_loaders_path.sh
/usr/local/greenplum-loaders-4.3.8.1-build-1/greenplum_loaders_path.sh

2. Source the greenplum_loaders_path.sh file.

source /usr/local/greenplum-loaders-4.3.8.1-build-1/greenplum_loaders_path.sh