Rebuilding a New Greenplum System From Backup If you need to rebuild your system on a completely different segment configuration, reinitialize a new array using gpinitsystem, then do a non-parallel restore. To rebuild your Greenplum array 1.First, you must have a backup of your data. It is good practice to make backups of your databases on a regular basis. 2.Make sure the Greenplum Database software is installed and configured on all hosts in the array. 3.Use the gprebuildsystem utility to reconstruct your Greenplum Database system from the catalog backup file created by gp_dump. For example: $ gprebuildsystem -f gp_catalog_0_1_2012103112453 -d /tmp If rebuilding the array on a different set of hosts than the system that was originally backed up, use the -c option. The utility will then prompt you for the new segment host configuration information. For example: $ gprebuildsystem -f gp_catalog_0_1_2012103112453 -d /tmp -c 4.You should now have your reconfigured Greenplum Database system up and running, and ready to restore your data from your backup files. |