Moves mirror segment instances to new locations.
gpmovemirrors -i <move_config_file> [-d <master_data_directory>] [-l <logfile_directory>] [-B <parallel_processes>] [-v] 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.
Before moving segments, the utility verifies that they are mirrors, and that their corresponding primary segments are up and are in synchronizing or resynchronizing mode.
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
$MASTER_DATA_DIRECTORYwill be used.
A configuration file containing information about which mirror segments to move, and where to move them.
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
pg_filespace_entry catalog tables):
filespaceOrder=[<filespace1_fsname>[:<filespace2_fsname>:...] <old_address>:<port>:fselocation \ [new_address:<port>:replication_port:fselocation[:<fselocation>:...]]
: Note that you only need to specify a name for
filespaceOrder if your system has multiple filespaces configured. If your system does not have additional filespaces configured besides the default
pg_system filespace, this file will only have one location (for the default data directory filespace,
pg_system does not need to be listed in the
filespaceOrder line. It will always be the first fselocation listed after replication_port.
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 (if you do not have additional filespaces configured besides the default
filespaceOrder=filespacea sdw1-1:61001:/data/mirrors/database/dbfast22/gp1 sdw2-1:61001:43001:/data/mirrors/database/dbfast222/gp1: /data/mirrors/database/dbfast222fs1