暂无图片
pg_catcheck提示Segmentation fault ,-v又不显示错误,请问什么问题??
我来答
分享
暂无图片 匿名用户
pg_catcheck提示Segmentation fault ,-v又不显示错误,请问什么问题??

 pg_catcheck -U postgres testdb
Segmentation fault (core dumped)  -----提示



$ pg_catcheck -U postgres testdb -v
verbose: detected server version 130003
verbose: detected PostgreSQL server
verbose: preloading table pg_authid because it is required in order to check pg_namespace
verbose: loading table pg_namespace
verbose: checking table pg_namespace (5 rows)
verbose: loading table pg_collation
verbose: checking table pg_collation (922 rows)
verbose: loading table pg_tablespace
verbose: checking table pg_tablespace (3 rows)
verbose: loading table pg_language
verbose: checking table pg_language (4 rows)
verbose: loading table pg_database
verbose: checking table pg_database (5 rows)
verbose: loading table pg_largeobject_metadata
verbose: checking table pg_largeobject_metadata (0 rows)
verbose: loading table pg_publication
verbose: checking table pg_publication (0 rows)
verbose: loading table pg_subscription
verbose: checking table pg_subscription (0 rows)
verbose: loading table pg_default_acl
verbose: checking table pg_default_acl (0 rows)
verbose: loading table pg_largeobject
verbose: checked table pg_largeobject (0 rows)
verbose: loading table pg_db_role_setting
verbose: checked table pg_db_role_setting (0 rows)
verbose: loading table pg_auth_members
verbose: checked table pg_auth_members (3 rows)
verbose: preloading table pg_class because it is required in order to check pg_type
verbose: loading table pg_type
verbose: checking table pg_type (416 rows)
verbose: loading table pg_proc
verbose: checking table pg_proc (3036 rows)
verbose: loading table pg_operator
verbose: checking table pg_operator (784 rows)
verbose: loading table pg_ts_parser
verbose: checking table pg_ts_parser (1 rows)
verbose: loading table pg_ts_config
verbose: checking table pg_ts_config (23 rows)
verbose: loading table pg_ts_template
verbose: checking table pg_ts_template (5 rows)
verbose: loading table pg_ts_dict
verbose: checking table pg_ts_dict (23 rows)
verbose: loading table pg_foreign_data_wrapper
verbose: checking table pg_foreign_data_wrapper (0 rows)
verbose: loading table pg_foreign_server
verbose: checking table pg_foreign_server (0 rows)
verbose: loading table pg_statistic_ext
verbose: checking table pg_statistic_ext (0 rows)
verbose: loading table pg_cast
verbose: checking table pg_cast (224 rows)
verbose: loading table pg_conversion
verbose: checking table pg_conversion (128 rows)
verbose: loading table pg_extension
verbose: checking table pg_extension (3 rows)
verbose: loading table pg_enum
verbose: checking table pg_enum (0 rows)
verbose: loading table pg_user_mapping
verbose: checking table pg_user_mapping (0 rows)
verbose: loading table pg_event_trigger
verbose: checking table pg_event_trigger (0 rows)
verbose: loading table pg_rewrite
verbose: checking table pg_rewrite (131 rows)
verbose: loading table pg_attrdef
verbose: checking table pg_attrdef (0 rows)
verbose: loading table pg_policy
verbose: checking table pg_policy (0 rows)
verbose: loading table pg_publication_rel
verbose: checking table pg_publication_rel (0 rows)
verbose: loading table pg_transform
verbose: checking table pg_transform (0 rows)
verbose: loading table pg_attribute
verbose: checking table pg_attribute (2889 rows)
verbose: loading table pg_foreign_table
verbose: checked table pg_foreign_table (0 rows)
verbose: loading table pg_inherits
verbose: checked table pg_inherits (0 rows)
verbose: loading table pg_aggregate
verbose: checked table pg_aggregate (138 rows)
verbose: loading table pg_ts_config_map
verbose: checked table pg_ts_config_map (437 rows)
verbose: loading table pg_statistic
verbose: checked table pg_statistic (402 rows)
verbose: loading table pg_init_privs
verbose: checked table pg_init_privs (178 rows)
verbose: loading table pg_sequence
verbose: checked table pg_sequence (0 rows)
verbose: loading table pg_subscription_rel
verbose: checked table pg_subscription_rel (0 rows)
verbose: loading table pg_statistic_ext_data
verbose: checked table pg_statistic_ext_data (0 rows)
verbose: preloading table pg_am because it is required in order to check pg_opfamily
verbose: loading table pg_opfamily
verbose: checking table pg_opfamily (109 rows)
verbose: checking table pg_class (390 rows)
verbose: loading table pg_opclass
verbose: checking table pg_opclass (130 rows)
verbose: loading table pg_amop
verbose: checking table pg_amop (723 rows)
verbose: loading table pg_amproc
verbose: checking table pg_amproc (483 rows)
verbose: loading table pg_index
verbose: checking table pg_index (155 rows)
verbose: loading table pg_constraint
verbose: checking table pg_constraint (2 rows)
verbose: loading table pg_trigger
verbose: checking table pg_trigger (0 rows)
verbose: loading table pg_range
verbose: checked table pg_range (6 rows)
verbose: loading table pg_depend
verbose: checked table pg_depend (7746 rows)
verbose: loading table pg_shdepend
Segmentation fault (core dumped)


版本v13.3

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
彭冲

你加一个选项 --enterprisedb试试,忽略一些edb的元数据错误。

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
postgreSQL any 可以用多个值查询吗?
回答 2
可以的,in列表系统也会转成any,可以通过执行计划观察。
greenplum节点宕机,pg_stat_activity卡了一堆进程杀不掉
回答 4
已采纳
补充下sql进程:(打马赛克的都是master节点)
tbase数据库扩容数据节点后,可以直接删掉吗?
回答 1
tbase扩容的dn主节点是无法删除的,但是如果是增加的备dn或者cn节点,则可以删除。
postgreSQL怎么自动更新时间戳?
回答 1
已采纳
创建表droptableifexiststs;createtablets(idbigserialprimarykey,tradeidinteger,emailvarchar(50),numintege
在PostgresSQL中,以下哪个不是块头记录的信息?
回答 1
已采纳
A数据块的位置
是不是postgreSQL 用多线程就能实现全局临时表?
回答 1
是的,PostgreSQL可以使用多线程来实现全局临时表。在PostgreSQL中,全局临时表是一种特殊的表类型,它可以在多个会话之间共享。使用多线程可以提高全局临时表的性能和并发性。
有postgreSQL13自动化部署脚本吗?
回答 3
上传附件:pginstall.sh
postgreSQL测试环境都是用什么操作系统搭建?
回答 3
已采纳
centos就行。
postgreSQL 分区索引和全局索引差距很大吗,数据量多少?
回答 1
pg只有本地索引,不存在全局索引
repmgr基础上,不用pgpool,用HAProxy可以实现读写分离+负载均衡吗?
回答 1
已采纳
repmgr可实现主备形式的高可用架构。haproxy实现的是负载均衡,它本身并不能针对读写进行分离。