Greenplum Command Center snstall fails with "FATAL: no pg_hba.conf entry for host "::1", user "gpmon", database "gpperfmon", SSL off"

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

During a new installation of Greenplum Command Center (GPCC), the following error is encountered:

[gpadmin@mdw gpseg-1]$ gpcmdr --setup

An instance name is used by the Greenplum Command Center as
a way to uniquely identify a Greenplum Database that has the monitoring
components installed and configured. This name is also used to control
specific instances of the Greenplum Command Center web UI. Instance names
can contain letters, digits and underscores and are not case sensitive.

Please enter a new instance name:
> gpcc 
The web component of the Greenplum Command Center can connect to a
monitor database on a remote Greenplum Database.


Is the master host for the Greenplum Database remote? Yy|Nn (default=N):
> n
The display name is shown in the web interface and does not need to be
a hostname.

What would you like to use for the display name for this instance:
> gpcc
What port does the Greenplum Database use? (default=5432):
> 
Creating instance schema in GPDB. Please wait ...
Failed to setup Command Center instance gpcc: Exception encountered while fetching GPDB version info Connection error for query select version();: FATAL: no pg_hba.conf entry for host "::1", user "gpmon", database "gpperfmon", SSL off

[gpadmin@mdw gpseg-1]$

Environment

Resolution

Add the line below to the pg_hba.conf file:

host    gpperfmon       gpmon   ::1/128 trust

Once the line is added, issue a gpstop -u command for the changes to take effect immediately without having to restart the Database. 

Retry the command center setup.