gpcheckcat命令

最新推荐文章于 2020-07-01 13:58:20 发布

rgb_rgb

最新推荐文章于 2020-07-01 13:58:20 发布

阅读量3.1k

点赞数

分类专栏： greenplum

本文链接：https://blog.csdn.net/rgb_rgb/article/details/18989815

版权

greenplum 专栏收录该内容

35 篇文章 1 订阅

订阅专栏

使用gpcheckcat命令检验你的系统目录的完整性

检查数据库：
nohup $GPHOME/bin/lib/gpcheckcat -p 5432 -v dbname| tee -a /tmp/checkcat.txt &

执行命令：

"$GPHOME/bin/lib/gpcheckcat -A"

查看日志：

cd /home/gpadmin/gpAdminLogs

1) PGOPTIONS='-c gp_session_role=utility' psql -h sdw1 -p 40013 sg
2) create table pg_attr_bkp as select * from pg_attribute where 0=1;
3) copy pg_attr_bkp from '/home/gpadmin/pg_attr_fix.txt';
set allow_system_table_mods = dml;
4) insert into pg_attribute (select * from pg_attr_bkp where not exists (select 1 from pg_attribute where pg_attribute.attrelid=pg_attr_bkp.attrelid));

PGOPTIONS='-c gp_session_role=utility' psql -h sdw1 -p 40013 sg -c "copy pg_attribute from '/home/gpadmin/pg_attr_fix.txt'";
PGOPTIONS='-c gp_session_role=utility' psql -h sdw1 -p 40014 sg -c "copy pg_attribute from '/home/gpadmin/pg_attr_fix.txt'";