This section describes each of the parameters that you can edit and assign in the
gpupgrade utility configuration file,
/usr/local/bin/greenplum/gpupgrade/gpupgrade_config. This file is a required option for the
gpupgrade initialize command.
# ---------------------------- # gpupgrade configuration file # ---------------------------- # The master port for the source Greenplum installation. source_master_port = # The installation path for the source Greenplum Database. # For example, /usr/local/<source-greenplum-version>. source_gphome = # The installation path for the target Greenplum Database. # For example, /usr/local/<target-greenplum-version>. target_gphome = # The mode is the upgrade method. The choices are “link” or “copy”. # The copy method creates a copy of the primary segments and performs the # upgrade on the copies. # The link method directly upgrades the primary segments. # mode = copy # For extensions installed outside of target_gphome include the extension’s # path in the dynamic_library_path value. For example, for pxf set # dynamic_library_path to /usr/local/pxf-gp6/gpextable. # dynamic_library_path = $libdir # The disk free ratio specifies what fraction of disk space must be free on # every host in order for gpupgrade to run. The ratio ranges from 0.0 to 1.0. # Recommended values are 0.6 [60%] for copy mode, and 0.2 [20%] for link mode. # disk_free_ratio = 0.6 # Whether to populate pg_hba.conf with hostnames or IP addresses during # execution of gpinitsystem and other utilities. # Choose "true" to use host names, or "false" to use IP addresses. # use_hba_hostnames = false # The temporary port range for the target Greenplum installation. # The temporary port range should be reserved prior to initializaton. # The format is a comma separated list of ports and port ranges, e.g. # “6000,6002-6005,6012.” The ports will be reconfigured to use the source # Greenplum installation port range once upgrade is complete. # temp_port_range = 50432-65535 # The port where the gpupgrade process will be running. # hub_port = 7527 # The port where the agent process will be running on all hosts. # agent_port = 6416
You specify the
gpupgrade initialize configuration file parameters via a INI-formatted file. A sample configuration file is provided in the directory where you extracted the downloaded
gpupgrade utility. The file has required and optional parameters:
See also Running gpupgrade Initialize for information about using the configuration file.
source_master_port = <port>
(Required) Identifies the master port number of the source cluster. For example:
source_gphome = <path>
(Required) Sets the location of the source cluster. For example:
target_gphome = <path>
(Required) Sets the location of the target cluster.
mode = <copy | link>
(Optional) By default set to
copy. Sets the mode for
copy mode requires 60% free data storage available. It copies all the source cluster files on each host to the target cluster. It requires more time during the upgrade but provides a faster revert option.
link mode requires 20% free data storage available. It creates hard links from the source cluster data directories to the new target data directories on each host. It requires less time during the upgrade but requires longer time to revert to the old cluster. It cannot be used in Greenplum clusters with no standby or mirror hosts.
dynamic_library_path = <path>
(Optional) Sets the
dynamic_library_path configuration parameter on the target Greenplum cluster to specify the location for extensions. This setting is required for extensions that are installed outside of
target_gphome, such as GPText, MADlib, and PXF. The default value is
$libdir. This table shows the install location for each extension:
|Extension||Default Install Location|
If you are specifying more than one install location because you are upgrading with multiple extensions, delimit the paths with a colon.
disk_free_ratio = <float>
(Optional) Indicates the free space requirement for the upgrade, with a range of 0.0 to 1.0. It is set by default to 0.6 - for
copy mode - which requires 60% free storage space. Uncomment this value and set to 0.2 (20%) if you have specified
link mode. Uncomment and set to
0.0 to skip this check during
use_hba_hostnames = <true | false>
(Optional) Indicates whether to use host names or IP addresses during Greenplum Database initialization, in
gpinitsystem and other utilities. The value of
use_hba_hostnames should match the value of
HBA_HOSTNAMES parameter in the Greenplum 5.x
gpinitsystem_config configuration file. For more information about
HBA_HOSTNAMES, see gpinitsystem.
temp_port_range = <port range>
(Optional) Specifies the range of ports to use when initializing the target cluster. Default is 50432-65535 and allocation starts from 50432 onwards.
hub_port = <int>
(Optional) Sets the master host port for the
gpupgrade hub process; 7527 by default. If you have an existing application running on the default hub port, change this value accordingly.
agent_port = <path>
(Optional) Sets the segment host’s port, where the
gpupgrade agent process runs; set to 6416 by default. If you have an existing application running on the default agent port, change this value accordingly.
See an example
gpupgrade_config configuration file in the directory where you extracted the downloaded
gpupgrade utility. See also Running gpupgrade Initialize for information about using the configuration file.