pg_catcheck

用于诊断系统目录是否损坏的工具

概览

扩展包名	版本	分类	许可证	语言
`pg_catcheck`	`1.6.0`	ADMIN	BSD-3-Clause	C

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
5160	`pg_catcheck`	否	是	否	是	否	否	-

相关扩展	`amcheck` `pg_checksums` `pg_surgery` `pg_orphaned` `pg_pathcheck` `pageinspect` `pg_isok` `pgdd` `ddlx` `meta`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PGDG	`1.6.0`	1817161514	`pg_catcheck`	-
RPM	PGDG	`1.6.0`	1817161514	`pg_catcheck_$v`	-
DEB	PGDG	`1.6.0`	1817161514	`postgresql-$v-pg-catcheck`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PGDG 1.6.0 el8.x86_64.pg18 : pg_catcheck_18 pg_catcheck_18-1.6.0-3PGDG.rhel8.x86_64.rpm PGDG · 1.6.0 · 43.4KiB	PGDG 1.6.0 el8.x86_64.pg17 : pg_catcheck_17 pg_catcheck_17-1.6.0-1PGDG.rhel8.x86_64.rpm PGDG · 1.6.0 · 43.3KiB pg_catcheck_17-1.5.0-1PGDG.rhel8.x86_64.rpm PGDG · 1.5.0 · 43.1KiB	PGDG 1.6.0 el8.x86_64.pg16 : pg_catcheck_16 pg_catcheck_16-1.6.0-1PGDG.rhel8.x86_64.rpm PGDG · 1.6.0 · 43.3KiB pg_catcheck_16-1.4.0-1PGDG.rhel8.x86_64.rpm PGDG · 1.4.0 · 43.1KiB	PGDG 1.6.0 el8.x86_64.pg15 : pg_catcheck_15 pg_catcheck_15-1.6.0-1PGDG.rhel8.x86_64.rpm PGDG · 1.6.0 · 43.2KiB pg_catcheck_15-1.3.0-1.rhel8.x86_64.rpm PGDG · 1.3.0 · 42.8KiB	PGDG 1.6.0 el8.x86_64.pg14 : pg_catcheck_14 pg_catcheck_14-1.6.0-1PGDG.rhel8.x86_64.rpm PGDG · 1.6.0 · 41.6KiB pg_catcheck_14-1.3.0-1.rhel8.x86_64.rpm PGDG · 1.3.0 · 41.0KiB pg_catcheck_14-1.2.0-3.rhel8.x86_64.rpm PGDG · 1.2.0 · 40.9KiB
el8.aarch64	PGDG 1.6.0 el8.aarch64.pg18 : pg_catcheck_18 pg_catcheck_18-1.6.0-3PGDG.rhel8.aarch64.rpm PGDG · 1.6.0 · 42.6KiB	PGDG 1.6.0 el8.aarch64.pg17 : pg_catcheck_17 pg_catcheck_17-1.6.0-1PGDG.rhel8.aarch64.rpm PGDG · 1.6.0 · 42.5KiB pg_catcheck_17-1.5.0-1PGDG.rhel8.aarch64.rpm PGDG · 1.5.0 · 42.4KiB	PGDG 1.6.0 el8.aarch64.pg16 : pg_catcheck_16 pg_catcheck_16-1.6.0-1PGDG.rhel8.aarch64.rpm PGDG · 1.6.0 · 42.6KiB pg_catcheck_16-1.4.0-1PGDG.rhel8.aarch64.rpm PGDG · 1.4.0 · 42.3KiB	PGDG 1.6.0 el8.aarch64.pg15 : pg_catcheck_15 pg_catcheck_15-1.6.0-1PGDG.rhel8.aarch64.rpm PGDG · 1.6.0 · 42.5KiB pg_catcheck_15-1.3.0-1.rhel8.aarch64.rpm PGDG · 1.3.0 · 41.9KiB	PGDG 1.6.0 el8.aarch64.pg14 : pg_catcheck_14 pg_catcheck_14-1.6.0-1PGDG.rhel8.aarch64.rpm PGDG · 1.6.0 · 41.2KiB pg_catcheck_14-1.3.0-1.rhel8.aarch64.rpm PGDG · 1.3.0 · 40.6KiB
el9.x86_64	PGDG 1.6.0 el9.x86_64.pg18 : pg_catcheck_18 pg_catcheck_18-1.6.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.6.0 · 37.8KiB pg_catcheck_18-1.6.0-3PGDG.rhel9.x86_64.rpm PGDG · 1.6.0 · 37.8KiB	PGDG 1.6.0 el9.x86_64.pg17 : pg_catcheck_17 pg_catcheck_17-1.6.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.6.0 · 37.8KiB pg_catcheck_17-1.6.0-1PGDG.rhel9.x86_64.rpm PGDG · 1.6.0 · 37.9KiB pg_catcheck_17-1.5.0-1PGDG.rhel9.x86_64.rpm PGDG · 1.5.0 · 37.7KiB	PGDG 1.6.0 el9.x86_64.pg16 : pg_catcheck_16 pg_catcheck_16-1.6.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.6.0 · 37.8KiB pg_catcheck_16-1.6.0-1PGDG.rhel9.x86_64.rpm PGDG · 1.6.0 · 37.9KiB pg_catcheck_16-1.4.0-1PGDG.rhel9.x86_64.rpm PGDG · 1.4.0 · 37.5KiB	PGDG 1.6.0 el9.x86_64.pg15 : pg_catcheck_15 pg_catcheck_15-1.6.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.6.0 · 37.8KiB pg_catcheck_15-1.6.0-1PGDG.rhel9.x86_64.rpm PGDG · 1.6.0 · 37.9KiB pg_catcheck_15-1.3.0-1.rhel9.x86_64.rpm PGDG · 1.3.0 · 37.7KiB	PGDG 1.6.0 el9.x86_64.pg14 : pg_catcheck_14 pg_catcheck_14-1.6.0-4PGDG.rhel9.8.x86_64.rpm PGDG · 1.6.0 · 37.5KiB pg_catcheck_14-1.6.0-1PGDG.rhel9.x86_64.rpm PGDG · 1.6.0 · 37.6KiB pg_catcheck_14-1.3.0-1.rhel9.x86_64.rpm PGDG · 1.3.0 · 37.7KiB
el9.aarch64	PGDG 1.6.0 el9.aarch64.pg18 : pg_catcheck_18 pg_catcheck_18-1.6.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.6.0 · 37.2KiB pg_catcheck_18-1.6.0-3PGDG.rhel9.aarch64.rpm PGDG · 1.6.0 · 37.2KiB	PGDG 1.6.0 el9.aarch64.pg17 : pg_catcheck_17 pg_catcheck_17-1.6.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.6.0 · 37.2KiB pg_catcheck_17-1.6.0-1PGDG.rhel9.aarch64.rpm PGDG · 1.6.0 · 37.3KiB pg_catcheck_17-1.5.0-1PGDG.rhel9.aarch64.rpm PGDG · 1.5.0 · 37.1KiB	PGDG 1.6.0 el9.aarch64.pg16 : pg_catcheck_16 pg_catcheck_16-1.6.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.6.0 · 37.2KiB pg_catcheck_16-1.6.0-1PGDG.rhel9.aarch64.rpm PGDG · 1.6.0 · 37.3KiB pg_catcheck_16-1.4.0-1PGDG.rhel9.aarch64.rpm PGDG · 1.4.0 · 36.9KiB	PGDG 1.6.0 el9.aarch64.pg15 : pg_catcheck_15 pg_catcheck_15-1.6.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.6.0 · 37.3KiB pg_catcheck_15-1.6.0-1PGDG.rhel9.aarch64.rpm PGDG · 1.6.0 · 37.3KiB pg_catcheck_15-1.3.0-1.rhel9.aarch64.rpm PGDG · 1.3.0 · 37.0KiB	PGDG 1.6.0 el9.aarch64.pg14 : pg_catcheck_14 pg_catcheck_14-1.6.0-4PGDG.rhel9.8.aarch64.rpm PGDG · 1.6.0 · 37.0KiB pg_catcheck_14-1.6.0-1PGDG.rhel9.aarch64.rpm PGDG · 1.6.0 · 37.0KiB pg_catcheck_14-1.3.0-1.rhel9.aarch64.rpm PGDG · 1.3.0 · 37.1KiB
el10.x86_64	PGDG 1.6.0 el10.x86_64.pg18 : pg_catcheck_18 pg_catcheck_18-1.6.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.6.0 · 38.6KiB pg_catcheck_18-1.6.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.6.0 · 38.9KiB	PGDG 1.6.0 el10.x86_64.pg17 : pg_catcheck_17 pg_catcheck_17-1.6.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.6.0 · 38.6KiB pg_catcheck_17-1.6.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.6.0 · 38.9KiB	PGDG 1.6.0 el10.x86_64.pg16 : pg_catcheck_16 pg_catcheck_16-1.6.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.6.0 · 38.6KiB pg_catcheck_16-1.6.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.6.0 · 38.9KiB	PGDG 1.6.0 el10.x86_64.pg15 : pg_catcheck_15 pg_catcheck_15-1.6.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.6.0 · 38.6KiB pg_catcheck_15-1.6.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.6.0 · 38.9KiB	PGDG 1.6.0 el10.x86_64.pg14 : pg_catcheck_14 pg_catcheck_14-1.6.0-4PGDG.rhel10.2.x86_64.rpm PGDG · 1.6.0 · 38.1KiB pg_catcheck_14-1.6.0-3PGDG.rhel10.x86_64.rpm PGDG · 1.6.0 · 38.4KiB
el10.aarch64	PGDG 1.6.0 el10.aarch64.pg18 : pg_catcheck_18 pg_catcheck_18-1.6.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.6.0 · 38.3KiB pg_catcheck_18-1.6.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.6.0 · 38.6KiB	PGDG 1.6.0 el10.aarch64.pg17 : pg_catcheck_17 pg_catcheck_17-1.6.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.6.0 · 38.2KiB pg_catcheck_17-1.6.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.6.0 · 38.6KiB	PGDG 1.6.0 el10.aarch64.pg16 : pg_catcheck_16 pg_catcheck_16-1.6.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.6.0 · 38.2KiB pg_catcheck_16-1.6.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.6.0 · 38.6KiB	PGDG 1.6.0 el10.aarch64.pg15 : pg_catcheck_15 pg_catcheck_15-1.6.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.6.0 · 38.2KiB pg_catcheck_15-1.6.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.6.0 · 38.6KiB	PGDG 1.6.0 el10.aarch64.pg14 : pg_catcheck_14 pg_catcheck_14-1.6.0-4PGDG.rhel10.2.aarch64.rpm PGDG · 1.6.0 · 37.8KiB pg_catcheck_14-1.6.0-3PGDG.rhel10.aarch64.rpm PGDG · 1.6.0 · 38.1KiB
d12.x86_64	PGDG 1.6.0 d12.x86_64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg12+1_amd64.deb PGDG · 1.6.0 · 34.4KiB	PGDG 1.6.0 d12.x86_64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg12+1_amd64.deb PGDG · 1.6.0 · 34.4KiB	PGDG 1.6.0 d12.x86_64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg12+1_amd64.deb PGDG · 1.6.0 · 34.4KiB	PGDG 1.6.0 d12.x86_64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg12+1_amd64.deb PGDG · 1.6.0 · 34.4KiB	PGDG 1.6.0 d12.x86_64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg12+1_amd64.deb PGDG · 1.6.0 · 33.9KiB
d12.aarch64	PGDG 1.6.0 d12.aarch64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg12+1_arm64.deb PGDG · 1.6.0 · 33.3KiB	PGDG 1.6.0 d12.aarch64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg12+1_arm64.deb PGDG · 1.6.0 · 33.4KiB	PGDG 1.6.0 d12.aarch64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg12+1_arm64.deb PGDG · 1.6.0 · 33.4KiB	PGDG 1.6.0 d12.aarch64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg12+1_arm64.deb PGDG · 1.6.0 · 33.4KiB	PGDG 1.6.0 d12.aarch64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg12+1_arm64.deb PGDG · 1.6.0 · 32.9KiB
d13.x86_64	PGDG 1.6.0 d13.x86_64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg13+1_amd64.deb PGDG · 1.6.0 · 34.6KiB	PGDG 1.6.0 d13.x86_64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg13+1_amd64.deb PGDG · 1.6.0 · 34.8KiB	PGDG 1.6.0 d13.x86_64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg13+1_amd64.deb PGDG · 1.6.0 · 34.8KiB	PGDG 1.6.0 d13.x86_64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg13+1_amd64.deb PGDG · 1.6.0 · 34.8KiB	PGDG 1.6.0 d13.x86_64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg13+1_amd64.deb PGDG · 1.6.0 · 34.0KiB
d13.aarch64	PGDG 1.6.0 d13.aarch64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg13+1_arm64.deb PGDG · 1.6.0 · 33.7KiB	PGDG 1.6.0 d13.aarch64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg13+1_arm64.deb PGDG · 1.6.0 · 33.7KiB	PGDG 1.6.0 d13.aarch64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg13+1_arm64.deb PGDG · 1.6.0 · 34.1KiB	PGDG 1.6.0 d13.aarch64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg13+1_arm64.deb PGDG · 1.6.0 · 33.9KiB	PGDG 1.6.0 d13.aarch64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg13+1_arm64.deb PGDG · 1.6.0 · 33.2KiB
u22.x86_64	PGDG 1.6.0 u22.x86_64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg22.04+1_amd64.deb PGDG · 1.6.0 · 35.4KiB	PGDG 1.6.0 u22.x86_64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg22.04+1_amd64.deb PGDG · 1.6.0 · 35.6KiB	PGDG 1.6.0 u22.x86_64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg22.04+1_amd64.deb PGDG · 1.6.0 · 35.5KiB	PGDG 1.6.0 u22.x86_64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg22.04+1_amd64.deb PGDG · 1.6.0 · 35.5KiB	PGDG 1.6.0 u22.x86_64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg22.04+1_amd64.deb PGDG · 1.6.0 · 34.6KiB
u22.aarch64	PGDG 1.6.0 u22.aarch64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg22.04+1_arm64.deb PGDG · 1.6.0 · 33.3KiB	PGDG 1.6.0 u22.aarch64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg22.04+1_arm64.deb PGDG · 1.6.0 · 33.6KiB	PGDG 1.6.0 u22.aarch64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg22.04+1_arm64.deb PGDG · 1.6.0 · 33.6KiB	PGDG 1.6.0 u22.aarch64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg22.04+1_arm64.deb PGDG · 1.6.0 · 33.6KiB	PGDG 1.6.0 u22.aarch64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg22.04+1_arm64.deb PGDG · 1.6.0 · 33.0KiB
u24.x86_64	PGDG 1.6.0 u24.x86_64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg24.04+1_amd64.deb PGDG · 1.6.0 · 35.3KiB	PGDG 1.6.0 u24.x86_64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg24.04+1_amd64.deb PGDG · 1.6.0 · 35.3KiB	PGDG 1.6.0 u24.x86_64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg24.04+1_amd64.deb PGDG · 1.6.0 · 35.3KiB	PGDG 1.6.0 u24.x86_64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg24.04+1_amd64.deb PGDG · 1.6.0 · 35.2KiB	PGDG 1.6.0 u24.x86_64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg24.04+1_amd64.deb PGDG · 1.6.0 · 34.5KiB
u24.aarch64	PGDG 1.6.0 u24.aarch64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg24.04+1_arm64.deb PGDG · 1.6.0 · 33.6KiB	PGDG 1.6.0 u24.aarch64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg24.04+1_arm64.deb PGDG · 1.6.0 · 33.7KiB	PGDG 1.6.0 u24.aarch64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg24.04+1_arm64.deb PGDG · 1.6.0 · 33.7KiB	PGDG 1.6.0 u24.aarch64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg24.04+1_arm64.deb PGDG · 1.6.0 · 33.6KiB	PGDG 1.6.0 u24.aarch64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg24.04+1_arm64.deb PGDG · 1.6.0 · 33.2KiB
u26.x86_64	PGDG 1.6.0 u26.x86_64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg26.04+1_amd64.deb PGDG · 1.6.0 · 35.5KiB	PGDG 1.6.0 u26.x86_64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg26.04+1_amd64.deb PGDG · 1.6.0 · 35.7KiB	PGDG 1.6.0 u26.x86_64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg26.04+1_amd64.deb PGDG · 1.6.0 · 35.8KiB	PGDG 1.6.0 u26.x86_64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg26.04+1_amd64.deb PGDG · 1.6.0 · 35.6KiB	PGDG 1.6.0 u26.x86_64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg26.04+1_amd64.deb PGDG · 1.6.0 · 34.9KiB
u26.aarch64	PGDG 1.6.0 u26.aarch64.pg18 : postgresql-18-pg-catcheck postgresql-18-pg-catcheck_1.6.0-2.pgdg26.04+1_arm64.deb PGDG · 1.6.0 · 33.8KiB	PGDG 1.6.0 u26.aarch64.pg17 : postgresql-17-pg-catcheck postgresql-17-pg-catcheck_1.6.0-2.pgdg26.04+1_arm64.deb PGDG · 1.6.0 · 34.0KiB	PGDG 1.6.0 u26.aarch64.pg16 : postgresql-16-pg-catcheck postgresql-16-pg-catcheck_1.6.0-2.pgdg26.04+1_arm64.deb PGDG · 1.6.0 · 34.0KiB	PGDG 1.6.0 u26.aarch64.pg15 : postgresql-15-pg-catcheck postgresql-15-pg-catcheck_1.6.0-2.pgdg26.04+1_arm64.deb PGDG · 1.6.0 · 33.9KiB	PGDG 1.6.0 u26.aarch64.pg14 : postgresql-14-pg-catcheck postgresql-14-pg-catcheck_1.6.0-2.pgdg26.04+1_arm64.deb PGDG · 1.6.0 · 33.4KiB

安装

您可以直接安装 pg_catcheck 扩展包的预置二进制包，首先确保 PGDG 仓库已经添加并启用：

BASH

pig repo add pgdg -u          # 添加 PGDG 仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装

BASH

pig install pg_catcheck;          # 当前活跃 PG 版本安装

pig

BASH

pig ext install -y pg_catcheck -v 18  # PG 18
pig ext install -y pg_catcheck -v 17  # PG 17
pig ext install -y pg_catcheck -v 16  # PG 16
pig ext install -y pg_catcheck -v 15  # PG 15
pig ext install -y pg_catcheck -v 14  # PG 14

dnf

BASH

dnf install -y pg_catcheck_18       # PG 18
dnf install -y pg_catcheck_17       # PG 17
dnf install -y pg_catcheck_16       # PG 16
dnf install -y pg_catcheck_15       # PG 15
dnf install -y pg_catcheck_14       # PG 14

apt

BASH

apt install -y postgresql-18-pg-catcheck   # PG 18
apt install -y postgresql-17-pg-catcheck   # PG 17
apt install -y postgresql-16-pg-catcheck   # PG 16
apt install -y postgresql-15-pg-catcheck   # PG 15
apt install -y postgresql-14-pg-catcheck   # PG 14

创建扩展：

SQL

CREATE EXTENSION pg_catcheck;

用法

pg_catcheck: 诊断系统目录损坏

pg_catcheck 是一个命令行工具，通过验证目录表之间的交叉引用来检查 PostgreSQL 系统目录是否损坏。它接受与其他 PostgreSQL 工具相同的连接参数（-h、-p、-U、-d）。

基本用法

BASH

pg_catcheck -h localhost -p 5432 -d mydb

未发现问题时的正常输出：

progress: done (0 inconsistencies, 0 warnings, 0 errors)

存在损坏时的示例输出

notice: pg_class row has invalid relnamespace "24580": no matching entry in pg_namespace
row identity: oid="24581" relname="foo" relkind="r"
notice: pg_type row has invalid typnamespace "24580": no matching entry in pg_namespace
row identity: oid="24583"
progress: done (4 inconsistencies, 0 warnings, 0 errors)

结果分类

不一致：目录交叉引用中的逻辑问题（例如悬空的 OID 引用）
警告：更严重的问题
错误：无法读取目录

选项

BASH

pg_catcheck --help                      # 完整选项列表
pg_catcheck --select-from-relations     # 同时检查缺失/不可访问的关系文件

连接

支持与 psql 相同的选项：-h 主机、-p 端口、-U 用户、-d 数据库，或连接字符串/URL。

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。