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

安装
编译安装

[pg12@localhostsoftware]$cdpg_catcheck/[pg12@localhostpg_catcheck]$lscheck_attribute.ccheck_depend.ccompat.cdefinitions.clog.cpg_catcheck.cpg_catcheck.projREADME.mdtypedefs.listcheck_class.ccheck_oids.ccompat.hLICENSEMakefilepg_catcheck.hpgrhash.csettings.projinc[pg12@localhostpg_catcheck]$[pg12@localhostpg_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-opg_catcheck.opg_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-ocheck_attribute.ocheck_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-ocheck_class.ocheck_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-ocheck_depend.ocheck_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-ocheck_oids.ocheck_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-ocompat.ocompat.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-odefinitions.odefinitions.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-olog.olog.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-opgrhash.opgrhash.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_SEMANTICSpg_catcheck.ocheck_attribute.ocheck_class.ocheck_depend.ocheck_oids.ocompat.odefinitions.olog.opgrhash.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-opg_catcheck[pg12@localhostpg_catcheck]$sudogmakeinstall[sudo]passwordforpg12:/usr/bin/mkdir-p'/usr/bin'/bin/sh/usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh-cpg_catcheck'/usr/bin'

体验

[pg12@localhostpg_catcheck]$pg_catcheck--helppg_catcheckiscatalogtablevalidationtoolforPostgreSQL.Usage:pg_catcheck[OPTION]...[DBNAME]Options:-c,--columncheckonlythenamedcolumns-t,--tablecheckonlycolumnsinthenamedtables-T,--exclude-tabledoNOTcheckthenamedtables-C,--exclude-columndoNOTcheckthenamedcolumns--target-version=VERSIONassumespecifiedtargetversion--enterprisedbassumeEnterpriseDBdatabase--postgresqlassumePostgreSQLdatabase-h,--host=HOSTNAMEdatabaseserverhostorsocketdirectory-p,--port=PORTdatabaseserverportnumber-q,--quietdonotdisplayprogressmessages-U,--username=USERNAMEconnectasspecifieddatabaseuser-v,--verboseenableverboseinternallogging-V,--versionoutputversioninformation,thenexit-?,--helpshowthishelp,thenexitReportbugsto<support@enterprisedb.com>.[pg12@localhostpg_catcheck]$pg_catcheck--postgresql-p5120-Upg12testdb-vverbose:detectedserverversion120001verbose:assumingPostgreSQLserververbose:preloadingtablepg_authidbecauseitisrequiredinordertocheckpg_namespaceverbose:loadingtablepg_namespaceverbose:checkingtablepg_namespace(6rows)verbose:loadingtablepg_collationverbose:checkingtablepg_collation(923rows)verbose:loadingtablepg_tablespaceverbose:checkingtablepg_tablespace(2rows)verbose:loadingtablepg_languageverbose:checkingtablepg_language(4rows)verbose:loadingtablepg_databaseverbose:checkingtablepg_database(7rows)verbose:loadingtablepg_largeobject_metadataverbose:checkingtablepg_largeobject_metadata(0rows)verbose:loadingtablepg_publicationverbose:checkingtablepg_publication(0rows)verbose:loadingtablepg_subscriptionverbose:checkingtablepg_subscription(0rows)verbose:loadingtablepg_default_aclverbose:checkingtablepg_default_acl(0rows)verbose:loadingtablepg_largeobjectverbose:checkingtablepg_largeobject(0rows)verbose:loadingtablepg_db_role_settingverbose:checkingtablepg_db_role_setting(0rows)verbose:loadingtablepg_auth_membersverbose:checkingtablepg_auth_members(3rows)verbose:preloadingtablepg_classbecauseitisrequiredinordertocheckpg_typeverbose:loadingtablepg_typeverbose:checkingtablepg_type(463rows)verbose:loadingtablepg_procverbose:checkingtablepg_proc(2964rows)verbose:loadingtablepg_operatorverbose:checkingtablepg_operator(770rows)verbose:loadingtablepg_ts_parserverbose:checkingtablepg_ts_parser(1rows)verbose:loadingtablepg_ts_configverbose:checkingtablepg_ts_config(22rows)verbose:loadingtablepg_ts_templateverbose:checkingtablepg_ts_template(5rows)verbose:loadingtablepg_ts_dictverbose:checkingtablepg_ts_dict(22rows)verbose:loadingtablepg_foreign_data_wrapperverbose:checkingtablepg_foreign_data_wrapper(0rows)verbose:loadingtablepg_foreign_serververbose:checkingtablepg_foreign_server(0rows)verbose:loadingtablepg_castverbose:checkingtablepg_cast(216rows)verbose:loadingtablepg_conversionverbose:checkingtablepg_conversion(132rows)verbose:loadingtablepg_extensionverbose:checkingtablepg_extension(1rows)verbose:loadingtablepg_enumverbose:checkingtablepg_enum(0rows)verbose:loadingtablepg_user_mappingverbose:checkingtablepg_user_mapping(0rows)verbose:loadingtablepg_event_triggerverbose:checkingtablepg_event_trigger(0rows)verbose:loadingtablepg_rewriteverbose:checkingtablepg_rewrite(126rows)verbose:loadingtablepg_attrdefverbose:checkingtablepg_attrdef(0rows)verbose:loadingtablepg_policyverbose:checkingtablepg_policy(0rows)verbose:loadingtablepg_publication_relverbose:checkingtablepg_publication_rel(0rows)verbose:loadingtablepg_statistic_extverbose:checkingtablepg_statistic_ext(0rows)verbose:loadingtablepg_transformverbose:checkingtablepg_transform(0rows)verbose:loadingtablepg_attributeverbose:checkingtablepg_attribute(3193rows)verbose:loadingtablepg_foreign_tableverbose:checkingtablepg_foreign_table(0rows)verbose:loadingtablepg_inheritsverbose:checkingtablepg_inherits(0rows)verbose:loadingtablepg_aggregateverbose:checkingtablepg_aggregate(136rows)verbose:loadingtablepg_ts_config_mapverbose:checkingtablepg_ts_config_map(418rows)verbose:loadingtablepg_statisticverbose:checkingtablepg_statistic(474rows)verbose:loadingtablepg_init_privsverbose:checkingtablepg_init_privs(171rows)verbose:loadingtablepg_sequenceverbose:checkingtablepg_sequence(0rows)verbose:loadingtablepg_subscription_relverbose:checkingtablepg_subscription_rel(0rows)verbose:preloadingtablepg_ambecauseitisrequiredinordertocheckpg_opfamilyverbose:loadingtablepg_opfamilyverbose:checkingtablepg_opfamily(107rows)verbose:checkingtablepg_class(435rows)verbose:loadingtablepg_opclassverbose:checkingtablepg_opclass(128rows)verbose:loadingtablepg_amopverbose:checkingtablepg_amop(715rows)verbose:loadingtablepg_amprocverbose:checkingtablepg_amproc(447rows)verbose:loadingtablepg_indexverbose:checkingtablepg_index(168rows)verbose:loadingtablepg_constraintverbose:checkingtablepg_constraint(6rows)verbose:loadingtablepg_triggerverbose:checkingtablepg_trigger(4rows)verbose:loadingtablepg_rangeverbose:checkingtablepg_range(6rows)verbose:loadingtablepg_dependverbose:checkingtablepg_depend(7722rows)verbose:loadingtablepg_shdependverbose:checkingtablepg_shdepend(10rows)verbose:loadingtablepg_descriptionverbose:checkingtablepg_description(4003rows)verbose:loadingtablepg_shdescriptionverbose:checkingtablepg_shdescription(3rows)verbose:loadingtablepg_seclabelverbose:checkingtablepg_seclabel(0rows)verbose:loadingtablepg_shseclabelverbose:checkingtablepg_shseclabel(0rows)verbose:loadingtablepg_partitioned_tableverbose:checkingtablepg_partitioned_table(0rows)progress:done(0inconsistencies,0warnings,0errors)[pg12@localhostpg_catcheck]$pg_catcheck--postgresql-p5120-Upg12testdbprogress:done(0inconsistencies,0warnings,0errors)

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

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