Pivotal Knowledge Base

Follow

How to determine IP address used by gptransfer to start gpfdist

Environment

Product Version
Pivotal Greenplum (GPDB) 4.3.x
OS RHEL 6.x
Others  

Purpose

This article is to show an approach about how to determine which IP address on a node will be used by gptransfer to start gpfdist instance.

Cause

As gptransfer will set up data transfer using gpfdist utility in source cluster sometimes it's necessary to know which IP address will be used if there are multiple IP addresses configured on the segment servers. 

Procedure

Please read through Migrating Data with Gptransfer in GPDB Admin Guide first to get more details about the gptransfer utility.

Then determine the IP address used by gptransfer to run gpfdist with following guidelines.

First, you need to check out which mode (fast or standard/slow mode) will be used in your situation.

If there is some old gptransfer log file available, you could run command grep "mode for transfer" gptransfer_<yyyymmdd>.log to check which mode is being used for your site.

  1. If it's fast mode then the address of the primary segment in system table gp_segment_configuration of source cluster will be used.
  2. If it's standard mode and source map file is provided to gptransfer, then the address in source map file will be used
  3. If it's standard mode and source map file is not provided to gptransfer, but source cluster and dest-cluster are on the same host, then the address of the primary segment in gp_segment_configuration of source cluster will be used.

Additional Information 

Comments

Powered by Zendesk