When a segment host is not recoverable
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
When a segment host is not recoverable
If a host is nonoperational, for example, due to hardware failure, recover the segments onto a spare set of hardware resources. If mirroring is enabled, you can recover a segment instance from its mirror onto an alternate host using the gprecoverseg utility. For example:
$ gprecoverseg -i recover_config_file
Where the format of the recover_config_file file is:
<failed_host>|<port>|<data_dir>[ <recovery_host>|<port>|<recovery_data_dir>]
For example, to recover to a different host than the failed host without additional tablespaces configured (besides the default pg_system tablespace):
sdw1-1|50001|/data1/mirror/gpseg16 sdw4-1|50001|/data1/recover1/gpseg16
For information about creating a segment instance recovery file, see gprecoverseg.
The new recovery segment host must be pre-installed with the Greenplum Database software and configured exactly as the existing segment hosts.