怎么安装PostgreSQL的插件pg_catcheck

这篇文章主要讲解了"怎么安装PostgreSQL的插件pg_catcheck"，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习"怎么安装PostgreSQL的插件pg_catcheck"吧！

安装
编译安装

[pg12@localhost software]$ cd pg_catcheck/[pg12@localhost pg_catcheck]$ lscheck_attribute.c  check_depend.c  compat.c  definitions.c  log.c     pg_catcheck.c  pg_catcheck.proj  README.md         typedefs.listcheck_class.c      check_oids.c    compat.h  LICENSE        Makefile  pg_catcheck.h  pgrhash.c         settings.projinc[pg12@localhost pg_catcheck]$ [pg12@localhost pg_catcheck]$ gmakegcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -I/appdb/pg12/pg12.1/include -I. -I./ -I/appdb/pg12/pg12.1/include/postgresql/server -I/appdb/pg12/pg12.1/include/postgresql/internal  -D_GNU_SOURCE -I/usr/include/libxml2   -c -o pg_catcheck.o pg_catcheck.c -MMD -MP -MF .deps/pg_catcheck.Pogcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -I/appdb/pg12/pg12.1/include -I. -I./ -I/appdb/pg12/pg12.1/include/postgresql/server -I/appdb/pg12/pg12.1/include/postgresql/internal  -D_GNU_SOURCE -I/usr/include/libxml2   -c -o check_attribute.o check_attribute.c -MMD -MP -MF .deps/check_attribute.Pogcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -I/appdb/pg12/pg12.1/include -I. -I./ -I/appdb/pg12/pg12.1/include/postgresql/server -I/appdb/pg12/pg12.1/include/postgresql/internal  -D_GNU_SOURCE -I/usr/include/libxml2   -c -o check_class.o check_class.c -MMD -MP -MF .deps/check_class.Pogcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -I/appdb/pg12/pg12.1/include -I. -I./ -I/appdb/pg12/pg12.1/include/postgresql/server -I/appdb/pg12/pg12.1/include/postgresql/internal  -D_GNU_SOURCE -I/usr/include/libxml2   -c -o check_depend.o check_depend.c -MMD -MP -MF .deps/check_depend.Pogcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -I/appdb/pg12/pg12.1/include -I. -I./ -I/appdb/pg12/pg12.1/include/postgresql/server -I/appdb/pg12/pg12.1/include/postgresql/internal  -D_GNU_SOURCE -I/usr/include/libxml2   -c -o check_oids.o check_oids.c -MMD -MP -MF .deps/check_oids.Pogcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -I/appdb/pg12/pg12.1/include -I. -I./ -I/appdb/pg12/pg12.1/include/postgresql/server -I/appdb/pg12/pg12.1/include/postgresql/internal  -D_GNU_SOURCE -I/usr/include/libxml2   -c -o compat.o compat.c -MMD -MP -MF .deps/compat.Pogcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -I/appdb/pg12/pg12.1/include -I. -I./ -I/appdb/pg12/pg12.1/include/postgresql/server -I/appdb/pg12/pg12.1/include/postgresql/internal  -D_GNU_SOURCE -I/usr/include/libxml2   -c -o definitions.o definitions.c -MMD -MP -MF .deps/definitions.Pogcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -I/appdb/pg12/pg12.1/include -I. -I./ -I/appdb/pg12/pg12.1/include/postgresql/server -I/appdb/pg12/pg12.1/include/postgresql/internal  -D_GNU_SOURCE -I/usr/include/libxml2   -c -o log.o log.c -MMD -MP -MF .deps/log.Pogcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -I/appdb/pg12/pg12.1/include -I. -I./ -I/appdb/pg12/pg12.1/include/postgresql/server -I/appdb/pg12/pg12.1/include/postgresql/internal  -D_GNU_SOURCE -I/usr/include/libxml2   -c -o pgrhash.o pgrhash.c -MMD -MP -MF .deps/pgrhash.Pogcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O0 -DOPTIMIZER_DEBUG -g3 -gdwarf-2 -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS pg_catcheck.o check_attribute.o check_class.o check_depend.o check_oids.o compat.o definitions.o log.o pgrhash.o  -L/appdb/pg12/pg12.1/lib   -Wl,--as-needed -Wl,-rpath,'/appdb/pg12/pg12.1/lib',--enable-new-dtags  -L/appdb/pg12/pg12.1/lib -lpgcommon -lpgport -L/appdb/pg12/pg12.1/lib -lpq  -lpgcommon -lpgport -lpthread -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lrt -lcrypt -ldl -lm  -o pg_catcheck[pg12@localhost pg_catcheck]$ sudo gmake install[sudo] password for pg12: /usr/bin/mkdir -p '/usr/bin'/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c  pg_catcheck '/usr/bin'

体验

[pg12@localhost pg_catcheck]$ pg_catcheck --helppg_catcheck is catalog table validation tool for PostgreSQL.Usage:  pg_catcheck [OPTION]... [DBNAME]Options:  -c, --column             check only the named columns  -t, --table              check only columns in the named tables  -T, --exclude-table      do NOT check the named tables  -C, --exclude-column     do NOT check the named columns  --target-version=VERSION assume specified target version  --enterprisedb           assume EnterpriseDB database  --postgresql             assume PostgreSQL database  -h, --host=HOSTNAME      database server host or socket directory  -p, --port=PORT          database server port number  -q, --quiet              do not display progress messages  -U, --username=USERNAME  connect as specified database user  -v, --verbose            enable verbose internal logging  -V, --version            output version information, then exit  -?, --help               show this help, then exitReport bugs to .[pg12@localhost pg_catcheck]$ pg_catcheck --postgresql -p 5120 -U pg12 testdb  -vverbose: detected server version 120001verbose: assuming PostgreSQL serververbose: preloading table pg_authid because it is required in order to check pg_namespaceverbose: loading table pg_namespaceverbose: checking table pg_namespace (6 rows)verbose: loading table pg_collationverbose: checking table pg_collation (923 rows)verbose: loading table pg_tablespaceverbose: checking table pg_tablespace (2 rows)verbose: loading table pg_languageverbose: checking table pg_language (4 rows)verbose: loading table pg_databaseverbose: checking table pg_database (7 rows)verbose: loading table pg_largeobject_metadataverbose: checking table pg_largeobject_metadata (0 rows)verbose: loading table pg_publicationverbose: checking table pg_publication (0 rows)verbose: loading table pg_subscriptionverbose: checking table pg_subscription (0 rows)verbose: loading table pg_default_aclverbose: checking table pg_default_acl (0 rows)verbose: loading table pg_largeobjectverbose: checking table pg_largeobject (0 rows)verbose: loading table pg_db_role_settingverbose: checking table pg_db_role_setting (0 rows)verbose: loading table pg_auth_membersverbose: checking table pg_auth_members (3 rows)verbose: preloading table pg_class because it is required in order to check pg_typeverbose: loading table pg_typeverbose: checking table pg_type (463 rows)verbose: loading table pg_procverbose: checking table pg_proc (2964 rows)verbose: loading table pg_operatorverbose: checking table pg_operator (770 rows)verbose: loading table pg_ts_parserverbose: checking table pg_ts_parser (1 rows)verbose: loading table pg_ts_configverbose: checking table pg_ts_config (22 rows)verbose: loading table pg_ts_templateverbose: checking table pg_ts_template (5 rows)verbose: loading table pg_ts_dictverbose: checking table pg_ts_dict (22 rows)verbose: loading table pg_foreign_data_wrapperverbose: checking table pg_foreign_data_wrapper (0 rows)verbose: loading table pg_foreign_serververbose: checking table pg_foreign_server (0 rows)verbose: loading table pg_castverbose: checking table pg_cast (216 rows)verbose: loading table pg_conversionverbose: checking table pg_conversion (132 rows)verbose: loading table pg_extensionverbose: checking table pg_extension (1 rows)verbose: loading table pg_enumverbose: checking table pg_enum (0 rows)verbose: loading table pg_user_mappingverbose: checking table pg_user_mapping (0 rows)verbose: loading table pg_event_triggerverbose: checking table pg_event_trigger (0 rows)verbose: loading table pg_rewriteverbose: checking table pg_rewrite (126 rows)verbose: loading table pg_attrdefverbose: checking table pg_attrdef (0 rows)verbose: loading table pg_policyverbose: checking table pg_policy (0 rows)verbose: loading table pg_publication_relverbose: checking table pg_publication_rel (0 rows)verbose: loading table pg_statistic_extverbose: checking table pg_statistic_ext (0 rows)verbose: loading table pg_transformverbose: checking table pg_transform (0 rows)verbose: loading table pg_attributeverbose: checking table pg_attribute (3193 rows)verbose: loading table pg_foreign_tableverbose: checking table pg_foreign_table (0 rows)verbose: loading table pg_inheritsverbose: checking table pg_inherits (0 rows)verbose: loading table pg_aggregateverbose: checking table pg_aggregate (136 rows)verbose: loading table pg_ts_config_mapverbose: checking table pg_ts_config_map (418 rows)verbose: loading table pg_statisticverbose: checking table pg_statistic (474 rows)verbose: loading table pg_init_privsverbose: checking table pg_init_privs (171 rows)verbose: loading table pg_sequenceverbose: checking table pg_sequence (0 rows)verbose: loading table pg_subscription_relverbose: checking table pg_subscription_rel (0 rows)verbose: preloading table pg_am because it is required in order to check pg_opfamilyverbose: loading table pg_opfamilyverbose: checking table pg_opfamily (107 rows)verbose: checking table pg_class (435 rows)verbose: loading table pg_opclassverbose: checking table pg_opclass (128 rows)verbose: loading table pg_amopverbose: checking table pg_amop (715 rows)verbose: loading table pg_amprocverbose: checking table pg_amproc (447 rows)verbose: loading table pg_indexverbose: checking table pg_index (168 rows)verbose: loading table pg_constraintverbose: checking table pg_constraint (6 rows)verbose: loading table pg_triggerverbose: checking table pg_trigger (4 rows)verbose: loading table pg_rangeverbose: checking table pg_range (6 rows)verbose: loading table pg_dependverbose: checking table pg_depend (7722 rows)verbose: loading table pg_shdependverbose: checking table pg_shdepend (10 rows)verbose: loading table pg_descriptionverbose: checking table pg_description (4003 rows)verbose: loading table pg_shdescriptionverbose: checking table pg_shdescription (3 rows)verbose: loading table pg_seclabelverbose: checking table pg_seclabel (0 rows)verbose: loading table pg_shseclabelverbose: checking table pg_shseclabel (0 rows)verbose: loading table pg_partitioned_tableverbose: checking table pg_partitioned_table (0 rows)progress: done (0 inconsistencies, 0 warnings, 0 errors)[pg12@localhost pg_catcheck]$ pg_catcheck --postgresql -p 5120 -U pg12 testdbprogress: done (0 inconsistencies, 0 warnings, 0 errors)

执行显示0 inconsistencies, 0 warnings, 0 errors，说明数据库的catalogs没有问题。

感谢各位的阅读，以上就是"怎么安装PostgreSQL的插件pg_catcheck"的内容了，经过本文的学习后，相信大家对怎么安装PostgreSQL的插件pg_catcheck这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是，小编将为大家推送更多相关知识点的文章，欢迎关注！