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
Comments