Windows installed gpload reports error "DLL load failed: The specified module could not be found." in Pivotal Greenplum

Products

• VMware Tanzu Greenplum

Issue/Introduction

gpload command reports the following error:

> gpload.py -?
gpload was unable to import The PyGreSQL Python module (pg.py) - DLL load failed: The specified module could not be found.

Environment

Product Version: 5.23
OS: Windows

Resolution

Check the version of python you are using with the following command:

> python -V

Note: gpload installed in a Windows environment requires python version 2.5.4.

If there is a newer version installed it will be trying to link to the incorrect DLL.

Remove conflicting Python versions from the following environment variables:

%PATH%
%PYTHONPATH%
%PYTHONHOME%

Create a new command prompt window and execute:

greenplum_loaders_path.bat

See the following documentation for details on installing the Greenplum Loader tools on Windows: https://docs.vmware.com/en/VMware-Greenplum/5/greenplum-database/client_tool_guides-load_tools_windows.html