Greenplum database catalog monitoring and repair
Monitoring
1. Check catalog consistency to ensure the catalog on each host in the cluster is consistent and in good state. For each database
run $GPHOME/bin/lib/gpcheckcat -O
2. Check persistent table catalog :In downtime window, and no users are on the system. For each database
run $GPHOME/bin/lib/gpcheckcat -R persistent
3. Check pg_class entry that does not have any correspond pg_attribute entry. In downtime window, and no users are on the system. For each database
run $GPHOME/bin/lib/gpcheckcat -R pgclass
4. Check temporary schema leaks :In downtime window, and no users are on the system. For each database
run $GPHOME/bin/lib/gpcheckcat -R namespace
5. Check constraints on randomly distributed tables : In downtime window, and no users are on the system. For each database
run $GPHOME/bin/lib/gpcheckcat -R distribution_policy
6. Check for dependency on non-existant objects : In downtime window, and no users are on the system. For each database
run $GPHOME/bin/lib/gpcheckcat -R dependency
Repair