greenplum_fdw connection fails: "ERROR: password is required ... DETAIL: Non-superuser cannot connect if the server does not request a password."

Products

• VMware Tanzu Greenplum
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite
• Greenplum

Issue/Introduction

When accessing Foreign Data Wrapper(FDW) tables in 6.27.2 the error "ERROR:  password is required" is reported. The error is specific to greenplum_fdw tables. Example:

db01=> select count(*) from schema.foreigntable ;
ERROR:  password is required
DETAIL:  Non-superuser cannot connect if the server does not request a password.
HINT:  Target server's authentication method must be changed.

 

Environment

Greenplum 6.28.0 

Greenplum 6.27.2

 

Cause

The greenplum_fdw library for GPDB6 will use the backend version of libpq instead of the frontend version of libpq which causes the error.

Resolution

greenplum_fdw is part of the Greenplum Streaming Server (GPSS).

The issue is fixed in GPSS 2.0.0 and above and GPSS 1.11.4 and above.

 

See Release Notes for 1.11 and Release Note for GPSS 2.0

Resolved Issues
Resolves an issue that greenplum_fdw is using the backend version of libpq by linking to the frontend version statically. This ensures that the frontend version of libpq is utilized, allowing connections initiated by GreenplumFDW to be correctly identified as remote.