How to change the IP Address of the Greenplum Server

Products

• VMware Tanzu Greenplum

Issue/Introduction

This article describes how to change the IP Address of a Greenplum Server.

 

Environment

Resolution

Most Greenplum installations use the /etc/hosts file on all the hosts to manage the DNS resolution. If you are updating the IP address of the public or private network, follow this process:

1. Stop the Greenplum Server ( gpstop )
2. Update the host files on the Master ( /etc/hosts )
3. Distribute the new file to all the segments ( gpscp -f <gpssh hostfile> /etc/hosts =: /etc )
4. Update Host IP addresses
5. Restart Greenplum ( gpstart )

Impact

• The gpscp command uses a hosts file (hostnames only) to distribute file(s) to all hosts listed.
• To avoid complications, it is recommended that you distribute a new host file with the new IP addresses included before making the change. Then, if desired, you can redistribute removing the old IP address.
• Then, follow the OS Vendor documentation to update the IP addresses of the interfaces on the hosts, using your preferred method (Command line, Configuration Files stored in /etc/sysconfig/network-scripts/, ...).
• The pg_hba.conf files for the segments (both primary and mirror), the master and the standby master may need to be updated with the new IP address. Check the files if they reference any of the old IPs and change them to the appropriate new IPs.

Additional Information

If you are using a DCA (Dell | EMC Computing Appliance), there are administrative scripts in the DCA Setup Utility to manage these tasks.

Environment:

• Pivotal Greenplum (GPDB) 4.3.12.0
• Operating System- Red Hat Enterprise Linux 6.x