Moves mirror segment instances to new locations.
gpmovemirrors -i <move_config_file> [-d <coordinator_data_directory>] [-l <logfile_directory>] [-b <segment_batch_size>] [-B <batch_size>] [-v] [--hba-hostnames <boolean>] gpmovemirrors -? gpmovemirrors --version
gpmovemirrors utility moves mirror segment instances to new locations. You may want to move mirrors to new locations to optimize distribution or data storage.
By default, the utility will prompt you for the file system location(s) where it will move the mirror segment data directories.
You must make sure that the user who runs
gpadmin user) has permissions to write to the data directory locations specified. You may want to create these directories on the segment hosts and
chown them to the appropriate user before running
128. If not specified, the utility will start recovering up to 64 segments in parallel on each host.
$COORDINATOR_DATA_DIRECTORYwill be used.
pg_hba.conffile when updating this file with addresses that can connect to Greenplum Database. When set to 0 – the default value – this utility uses IP addresses when updating this file. When set to 1, this utility uses host names when updating this file. For consistency, use the same value that was specified for
HBA_HOSTNAMESwhen the Greenplum Database system was initialized. For information about how Greenplum Database resolves host names in the
pg_hba.conffile, see Configuring Client Authentication.
You must have one mirror segment listed for each primary segment in the system. Each line inside the configuration file has the following format (as per attributes in the
gp_segment_configuration catalog table):
<new_address> are the host names or IP addresses of the segment hosts,
<port> is the communication port, and
<data_dir> is the segment instance data directory.
Moves mirrors from an existing Greenplum Database system to a different set of hosts:
$ gpmovemirrors -i move_config_file
move_config_file looks something like this:
sdw2|50000|/data2/mirror/gpseg0 sdw3|50000|/data/mirror/gpseg0 sdw2|50001|/data2/mirror/gpseg1 sdw4|50001|/data/mirror/gpseg1 sdw3|50002|/data2/mirror/gpseg2 sdw1|50002|/data/mirror/gpseg2