Partitioning Catalogs 248 About the Greenplum 6 and 7 Partitioning Catalogs 248 Why are Migration Tasks Required? 248 pg_partitions 248 Examples Retrieving Similar Information in Greenplum 7 250 partitionname the Cluster 893 Requirements for New Host 893 Steps to Recover to a New Host 893 Post-Recovery Tasks 894 Recovering a Failed Coordinator 894 To activate the standby coordinator 894 Restoring Coordinator Table Redistribution 917 Viewing Expansion Status 918 Viewing Table Status 918 Post Expansion Tasks 918 Removing the Expansion Schema 918 Setting Up PXF on the New Host 919 PXF 5 919 PXF 6 919

the Cluster 530 Requirements for New Host 530 Steps to Recover to a New Host 531 Post-Recovery Tasks 531 Recovering a Failed Master 531 Recovering a Failed Master 0 To activate the standby master Redistribution 602 Viewing Expansion Status 602 Viewing Table Status 603 Post Expansion Tasks 603 Post Expansion Tasks 0 Removing the Expansion Schema 603 Setting Up PXF on the New Host 604 PXF 5 604 Using gp_toolkit 613 SQL Standard Error Codes 614 Routine System Maintenance Tasks 621 Routine System Maintenance Tasks 0 Routine Vacuum and Analyze 622 Transaction ID Management 622 Recovering from

the Cluster 539 Requirements for New Host 539 Steps to Recover to a New Host 540 Post-Recovery Tasks 540 Recovering a Failed Master 540 Recovering a Failed Master 0 To activate the standby master Redistribution 611 Viewing Expansion Status 611 Viewing Table Status 612 Post Expansion Tasks 612 Post Expansion Tasks 0 Removing the Expansion Schema 612 Setting Up PXF on the New Host 613 PXF 5 613 Using gp_toolkit 622 SQL Standard Error Codes 622 Routine System Maintenance Tasks 630 Routine System Maintenance Tasks 0 Routine Vacuum and Analyze 630 Transaction ID Management 631 Recovering from

VMware Greenplum 6 Documentation VMware, Inc 47 Steps to Recover to a New Host 1098 Post-Recovery Tasks 1099 Recovering a Failed Master 1099 To activate the standby master 1099 Restoring Master Mirroring Table Redistribution 1121 Viewing Expansion Status 1121 Viewing Table Status 1122 Post Expansion Tasks 1122 Removing the Expansion Schema 1122 Setting Up PXF on the New Host 1123 PXF 5 1123 PXF 6 1123 Log Files 1134 Using gp_toolkit 1134 SQL Standard Error Codes 1135 Routine System Maintenance Tasks 1143 Routine Vacuum and Analyze 1143 Transaction ID Management 1144 Recovering from a Transaction

Cluster 1065 Requirements for New Host 1065 Steps to Recover to a New Host 1065 Post-Recovery Tasks 1066 Recovering a Failed Master 1066 To activate the standby master 1066 Restoring Master Mirroring Viewing Table Status 1088 VMware Tanzu Greenplum 6 Documentation VMware, Inc 49 Post Expansion Tasks 1088 Removing the Expansion Schema 1088 Setting Up PXF on the New Host 1089 PXF 5 1089 PXF 6 1089 Log Files 1100 Using gp_toolkit 1100 SQL Standard Error Codes 1101 Routine System Maintenance Tasks 1109 VMware Tanzu Greenplum 6 Documentation VMware, Inc 50 Routine Vacuum and Analyze 1109 Transaction

Cluster 1060 Requirements for New Host 1060 Steps to Recover to a New Host 1061 Post-Recovery Tasks 1061 Recovering a Failed Master 1061 To activate the standby master 1061 Restoring Master Mirroring Table Redistribution 1083 Viewing Expansion Status 1083 Viewing Table Status 1083 Post Expansion Tasks 1083 Removing the Expansion Schema 1084 Setting Up PXF on the New Host 1084 PXF 5 1084 PXF 6 1084 Log Files 1095 Using gp_toolkit 1095 SQL Standard Error Codes 1096 Routine System Maintenance Tasks 1104 Routine Vacuum and Analyze 1104 Transaction ID Management 1105 Recovering from a Transaction

VMware, Inc 46 Requirements for New Host 928 Steps to Recover to a New Host 928 Post-Recovery Tasks 929 Recovering a Failed Master 929 To activate the standby master 929 Restoring Master Mirroring Table Redistribution 948 Viewing Expansion Status 948 Viewing Table Status 949 Post Expansion Tasks 949 Removing the Expansion Schema 949 Setting Up PXF on the New Host 949 PXF 5 949 PXF 6 950 Server Log Files 958 Using gp_toolkit 958 SQL Standard Error Codes 958 Routine System Maintenance Tasks 967 Routine Vacuum and Analyze 967 Transaction ID Management 968 Recovering from a Transaction

Cluster 1114 Requirements for New Host 1114 Steps to Recover to a New Host 1114 Post-Recovery Tasks 1115 VMware Greenplum 6 Documentation VMware by Broadcom 52 Recovering a Failed Master 1115 To Table Redistribution 1137 Viewing Expansion Status 1138 Viewing Table Status 1138 Post Expansion Tasks 1138 Removing the Expansion Schema 1138 Setting Up PXF on the New Host 1139 PXF 5 1139 PXF 6 1139 Log Files 1150 Using gp_toolkit 1150 SQL Standard Error Codes 1151 Routine System Maintenance Tasks 1159 Routine Vacuum and Analyze 1159 Transaction ID Management 1160 Recovering from a Transaction

Cluster 1082 Requirements for New Host 1082 Steps to Recover to a New Host 1082 Post-Recovery Tasks 1083 Recovering a Failed Master 1083 To activate the standby master 1083 Restoring Master Mirroring Table Redistribution 1105 Viewing Expansion Status 1106 Viewing Table Status 1106 Post Expansion Tasks 1106 Removing the Expansion Schema 1106 Setting Up PXF on the New Host 1107 PXF 5 1107 PXF 6 1107 Log Files 1118 Using gp_toolkit 1118 SQL Standard Error Codes 1119 Routine System Maintenance Tasks 1127 Routine Vacuum and Analyze 1127 Transaction ID Management 1128 Recovering from a Transaction

Greenplum v6.20 Documentation VMware, Inc. 26 Steps to Recover to a New Host 532 Post-Recovery Tasks 533 Recovering a Failed Master 533 To activate the standby master 533 Restoring Master Mirroring Table Redistribution 602 Viewing Expansion Status 602 Viewing Table Status 602 Post Expansion Tasks 603 Removing the Expansion Schema 603 Setting Up PXF on the New Host 603 PXF 5 603 PXF 6 603 Server Log Files 613 Using gp_toolkit 613 SQL Standard Error Codes 613 Routine System Maintenance Tasks 621 Routine Vacuum and Analyze 622 Transaction ID Management 622 Recovering from a Transaction