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