The "hostname" value in gp_segment_configuration table is incorrect after gpinitsystem
book
Article ID: 296800
calendar_today
Updated On:
Products
VMware Tanzu Greenplum
Issue/Introduction
When the segment servers in a new cluster have more than one IP that will be used in the interconnect, gpinitsystem will incorrectly set the "hostname" value for the primary segments in the gp_segment_configuration table. This can cause errors when running "gppkg" utility to install Greenplum packages. The error message similar to:
Environment
Product Version: 6.20
Resolution
Workaround: After the gpinitsystem is finidhed, manually set the "hostname" in the "gp_segment_configuration" table for each segment to the correct value. This will need to be done by Greenplum Support.