FATAL: empty password returned by client

Products

• VMware Tanzu Greenplum

Issue/Introduction

gprestore or gpbackup returns the following error message:

FATAL: empty password returned by client (SQLSTATE 28P01)

Environment

Product Version: 6.5

Resolution

The pg_hba.conf file is not allowing user gpadmin to login without a password.

The pg_hba.conf file needs the following entries:

local   all         gpadmin         ident
host    all         gpadmin         127.0.0.1/28    trust
host    all         gpadmin         localIPAddress/32       trust

If any of the above entries are not present in the $MASTER_DATA_DIRECTORY/pg_hba.conf file:
 

1. Make a copy of the existing file
2. Edit the file with vi and add the missing entries.
3. Run "gpstop -u" for the new file to take effect.