pgautofailover

PG 自动故障迁移

概览

扩展包名	版本	分类	许可证	语言
`pgautofailover`	`2.2`	ADMIN	PostgreSQL	C

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

相关扩展	`btree_gist` `repmgr` `pg_failover_slots` `bgw_replstatus` `pgpool_adm` `pglogical` `pgactive` `pglogical_ticker`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PGDG	`2.2`	1817161514	`pgautofailover`	`btree_gist`
RPM	PGDG	`2.2`	1817161514	`pg_auto_failover_$v`	-
DEB	PGDG	`2.2`	1817161514	`postgresql-$v-auto-failover`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 2.2 el8.x86_64.pg18 : pg_auto_failover_18 pg_auto_failover_18-2.2-5PIGSTY.el8.x86_64.rpm PIGSTY · 2.2 · 837.3KiB	PGDG 2.2 el8.x86_64.pg17 : pg_auto_failover_17 pg_auto_failover_17-2.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.2 · 812.9KiB	PGDG 2.2 el8.x86_64.pg16 : pg_auto_failover_16 pg_auto_failover_16-2.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.2 · 812.5KiB pg_auto_failover_16-2.1-1PGDG.rhel8.x86_64.rpm PGDG · 2.1 · 844.0KiB	PGDG 2.2 el8.x86_64.pg15 : pg_auto_failover_15 pg_auto_failover_15-2.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.2 · 812.6KiB pg_auto_failover_15-2.1-1PGDG.rhel8.x86_64.rpm PGDG · 2.1 · 843.6KiB pg_auto_failover_15-2.0-1.rhel8.x86_64.rpm PGDG · 2.0 · 842.5KiB	PGDG 2.2 el8.x86_64.pg14 : pg_auto_failover_14 pg_auto_failover_14-2.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.2 · 810.9KiB pg_auto_failover_14-2.1-1PGDG.rhel8.x86_64.rpm PGDG · 2.1 · 841.9KiB pg_auto_failover_14-2.0-1.rhel8.x86_64.rpm PGDG · 2.0 · 840.6KiB pg_auto_failover_14-1.6.4-1.rhel8.x86_64.rpm PGDG · 1.6.4 · 994.9KiB pg_auto_failover_14-1.6.2-1.rhel8.x86_64.rpm PGDG · 1.6.2 · 929.2KiB
el8.aarch64	PIGSTY 2.2 el8.aarch64.pg18 : pg_auto_failover_18 pg_auto_failover_18-2.2-5PIGSTY.el8.aarch64.rpm PIGSTY · 2.2 · 837.3KiB	PGDG 2.2 el8.aarch64.pg17 : pg_auto_failover_17 pg_auto_failover_17-2.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.2 · 809.9KiB	PGDG 2.2 el8.aarch64.pg16 : pg_auto_failover_16 pg_auto_failover_16-2.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.2 · 809.4KiB pg_auto_failover_16-2.1-1PGDG.rhel8.aarch64.rpm PGDG · 2.1 · 843.8KiB	PGDG 2.2 el8.aarch64.pg15 : pg_auto_failover_15 pg_auto_failover_15-2.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.2 · 809.3KiB pg_auto_failover_15-2.1-1PGDG.rhel8.aarch64.rpm PGDG · 2.1 · 843.0KiB pg_auto_failover_15-2.0-1.rhel8.aarch64.rpm PGDG · 2.0 · 841.6KiB	PGDG 2.2 el8.aarch64.pg14 : pg_auto_failover_14 pg_auto_failover_14-2.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.2 · 808.0KiB pg_auto_failover_14-2.1-1PGDG.rhel8.aarch64.rpm PGDG · 2.1 · 841.4KiB pg_auto_failover_14-2.0-1.rhel8.aarch64.rpm PGDG · 2.0 · 840.1KiB
el9.x86_64	PIGSTY 2.2 el9.x86_64.pg18 : pg_auto_failover_18 pg_auto_failover_18-2.2-5PIGSTY.el9.x86_64.rpm PIGSTY · 2.2 · 789.9KiB	PGDG 2.2 el9.x86_64.pg17 : pg_auto_failover_17 pg_auto_failover_17-2.2-4PGDG.rhel9.8.x86_64.rpm PGDG · 2.2 · 786.4KiB pg_auto_failover_17-2.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.2 · 786.3KiB	PGDG 2.2 el9.x86_64.pg16 : pg_auto_failover_16 pg_auto_failover_16-2.2-4PGDG.rhel9.8.x86_64.rpm PGDG · 2.2 · 786.4KiB pg_auto_failover_16-2.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.2 · 786.3KiB pg_auto_failover_16-2.1-1PGDG.rhel9.x86_64.rpm PGDG · 2.1 · 807.5KiB	PGDG 2.2 el9.x86_64.pg15 : pg_auto_failover_15 pg_auto_failover_15-2.2-4PGDG.rhel9.8.x86_64.rpm PGDG · 2.2 · 789.5KiB pg_auto_failover_15-2.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.2 · 789.5KiB pg_auto_failover_15-2.1-1PGDG.rhel9.x86_64.rpm PGDG · 2.1 · 811.6KiB pg_auto_failover_15-2.0-1.rhel9.x86_64.rpm PGDG · 2.0 · 812.1KiB	PGDG 2.2 el9.x86_64.pg14 : pg_auto_failover_14 pg_auto_failover_14-2.2-4PGDG.rhel9.8.x86_64.rpm PGDG · 2.2 · 789.0KiB pg_auto_failover_14-2.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.2 · 789.0KiB pg_auto_failover_14-2.1-1PGDG.rhel9.x86_64.rpm PGDG · 2.1 · 811.2KiB pg_auto_failover_14-2.0-1.rhel9.x86_64.rpm PGDG · 2.0 · 811.7KiB pg_auto_failover_14-1.6.4-1.rhel9.x86_64.rpm PGDG · 1.6.4 · 966.2KiB
el9.aarch64	PIGSTY 2.2 el9.aarch64.pg18 : pg_auto_failover_18 pg_auto_failover_18-2.2-5PIGSTY.el9.aarch64.rpm PIGSTY · 2.2 · 792.8KiB	PGDG 2.2 el9.aarch64.pg17 : pg_auto_failover_17 pg_auto_failover_17-2.2-4PGDG.rhel9.8.aarch64.rpm PGDG · 2.2 · 789.1KiB pg_auto_failover_17-2.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.2 · 789.2KiB	PGDG 2.2 el9.aarch64.pg16 : pg_auto_failover_16 pg_auto_failover_16-2.2-4PGDG.rhel9.8.aarch64.rpm PGDG · 2.2 · 789.2KiB pg_auto_failover_16-2.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.2 · 789.1KiB pg_auto_failover_16-2.1-1PGDG.rhel9.aarch64.rpm PGDG · 2.1 · 817.4KiB	PGDG 2.2 el9.aarch64.pg15 : pg_auto_failover_15 pg_auto_failover_15-2.2-4PGDG.rhel9.8.aarch64.rpm PGDG · 2.2 · 792.2KiB pg_auto_failover_15-2.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.2 · 792.9KiB pg_auto_failover_15-2.1-1PGDG.rhel9.aarch64.rpm PGDG · 2.1 · 820.9KiB pg_auto_failover_15-2.0-1.rhel9.aarch64.rpm PGDG · 2.0 · 821.5KiB	PGDG 2.2 el9.aarch64.pg14 : pg_auto_failover_14 pg_auto_failover_14-2.2-4PGDG.rhel9.8.aarch64.rpm PGDG · 2.2 · 791.7KiB pg_auto_failover_14-2.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.2 · 792.5KiB pg_auto_failover_14-2.1-1PGDG.rhel9.aarch64.rpm PGDG · 2.1 · 820.6KiB pg_auto_failover_14-2.0-1.rhel9.aarch64.rpm PGDG · 2.0 · 821.0KiB
el10.x86_64	PIGSTY 2.2 el10.x86_64.pg18 : pg_auto_failover_18 pg_auto_failover_18-2.2-5PIGSTY.el10.x86_64.rpm PIGSTY · 2.2 · 791.4KiB	PGDG 2.2 el10.x86_64.pg17 : pg_auto_failover_17 pg_auto_failover_17-2.2-4PGDG.rhel10.2.x86_64.rpm PGDG · 2.2 · 788.1KiB pg_auto_failover_17-2.2-1PGDG.rhel10.x86_64.rpm PGDG · 2.2 · 788.0KiB	PGDG 2.2 el10.x86_64.pg16 : pg_auto_failover_16 pg_auto_failover_16-2.2-4PGDG.rhel10.2.x86_64.rpm PGDG · 2.2 · 787.9KiB pg_auto_failover_16-2.2-1PGDG.rhel10.x86_64.rpm PGDG · 2.2 · 788.1KiB	PGDG 2.2 el10.x86_64.pg15 : pg_auto_failover_15 pg_auto_failover_15-2.2-4PGDG.rhel10.2.x86_64.rpm PGDG · 2.2 · 791.6KiB pg_auto_failover_15-2.2-1PGDG.rhel10.x86_64.rpm PGDG · 2.2 · 791.7KiB	PGDG 2.2 el10.x86_64.pg14 : pg_auto_failover_14 pg_auto_failover_14-2.2-4PGDG.rhel10.2.x86_64.rpm PGDG · 2.2 · 792.1KiB pg_auto_failover_14-2.2-1PGDG.rhel10.x86_64.rpm PGDG · 2.2 · 792.2KiB
el10.aarch64	PIGSTY 2.2 el10.aarch64.pg18 : pg_auto_failover_18 pg_auto_failover_18-2.2-5PIGSTY.el10.aarch64.rpm PIGSTY · 2.2 · 789.1KiB	PGDG 2.2 el10.aarch64.pg17 : pg_auto_failover_17 pg_auto_failover_17-2.2-4PGDG.rhel10.2.aarch64.rpm PGDG · 2.2 · 785.8KiB pg_auto_failover_17-2.2-1PGDG.rhel10.aarch64.rpm PGDG · 2.2 · 785.7KiB	PGDG 2.2 el10.aarch64.pg16 : pg_auto_failover_16 pg_auto_failover_16-2.2-4PGDG.rhel10.2.aarch64.rpm PGDG · 2.2 · 785.8KiB pg_auto_failover_16-2.2-1PGDG.rhel10.aarch64.rpm PGDG · 2.2 · 785.7KiB	PGDG 2.2 el10.aarch64.pg15 : pg_auto_failover_15 pg_auto_failover_15-2.2-4PGDG.rhel10.2.aarch64.rpm PGDG · 2.2 · 789.0KiB pg_auto_failover_15-2.2-1PGDG.rhel10.aarch64.rpm PGDG · 2.2 · 788.8KiB	PGDG 2.2 el10.aarch64.pg14 : pg_auto_failover_14 pg_auto_failover_14-2.2-4PGDG.rhel10.2.aarch64.rpm PGDG · 2.2 · 789.8KiB pg_auto_failover_14-2.2-1PGDG.rhel10.aarch64.rpm PGDG · 2.2 · 789.6KiB
d12.x86_64	PGDG 2.2 d12.x86_64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg12+1_amd64.deb PGDG · 2.2 · 378.2KiB postgresql-18-auto-failover_2.2-3.pgdg12+1_amd64.deb PGDG · 2.2 · 377.7KiB	PGDG 2.2 d12.x86_64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg12+1_amd64.deb PGDG · 2.2 · 374.0KiB postgresql-17-auto-failover_2.2-3.pgdg12+1_amd64.deb PGDG · 2.2 · 374.2KiB	PGDG 2.2 d12.x86_64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg12+1_amd64.deb PGDG · 2.2 · 368.4KiB postgresql-16-auto-failover_2.2-3.pgdg12+1_amd64.deb PGDG · 2.2 · 368.8KiB	PGDG 2.2 d12.x86_64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg12+1_amd64.deb PGDG · 2.2 · 368.6KiB postgresql-15-auto-failover_2.2-3.pgdg12+1_amd64.deb PGDG · 2.2 · 368.4KiB	PGDG 2.2 d12.x86_64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg12+1_amd64.deb PGDG · 2.2 · 362.6KiB postgresql-14-auto-failover_2.2-3.pgdg12+1_amd64.deb PGDG · 2.2 · 362.7KiB
d12.aarch64	PGDG 2.2 d12.aarch64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg12+1_arm64.deb PGDG · 2.2 · 373.7KiB postgresql-18-auto-failover_2.2-3.pgdg12+1_arm64.deb PGDG · 2.2 · 373.6KiB	PGDG 2.2 d12.aarch64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg12+1_arm64.deb PGDG · 2.2 · 370.7KiB postgresql-17-auto-failover_2.2-3.pgdg12+1_arm64.deb PGDG · 2.2 · 370.7KiB	PGDG 2.2 d12.aarch64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg12+1_arm64.deb PGDG · 2.2 · 364.8KiB postgresql-16-auto-failover_2.2-3.pgdg12+1_arm64.deb PGDG · 2.2 · 365.9KiB	PGDG 2.2 d12.aarch64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg12+1_arm64.deb PGDG · 2.2 · 365.3KiB postgresql-15-auto-failover_2.2-3.pgdg12+1_arm64.deb PGDG · 2.2 · 365.9KiB	PGDG 2.2 d12.aarch64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg12+1_arm64.deb PGDG · 2.2 · 358.9KiB postgresql-14-auto-failover_2.2-3.pgdg12+1_arm64.deb PGDG · 2.2 · 359.4KiB
d13.x86_64	PGDG 2.2 d13.x86_64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg13+1_amd64.deb PGDG · 2.2 · 379.7KiB postgresql-18-auto-failover_2.2-3.pgdg13+1_amd64.deb PGDG · 2.2 · 379.1KiB	PGDG 2.2 d13.x86_64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg13+1_amd64.deb PGDG · 2.2 · 374.8KiB postgresql-17-auto-failover_2.2-3.pgdg13+1_amd64.deb PGDG · 2.2 · 375.0KiB	PGDG 2.2 d13.x86_64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg13+1_amd64.deb PGDG · 2.2 · 369.6KiB postgresql-16-auto-failover_2.2-3.pgdg13+1_amd64.deb PGDG · 2.2 · 369.8KiB	PGDG 2.2 d13.x86_64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg13+1_amd64.deb PGDG · 2.2 · 369.7KiB postgresql-15-auto-failover_2.2-3.pgdg13+1_amd64.deb PGDG · 2.2 · 370.1KiB	PGDG 2.2 d13.x86_64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg13+1_amd64.deb PGDG · 2.2 · 364.3KiB postgresql-14-auto-failover_2.2-3.pgdg13+1_amd64.deb PGDG · 2.2 · 364.0KiB
d13.aarch64	PGDG 2.2 d13.aarch64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg13+1_arm64.deb PGDG · 2.2 · 374.8KiB postgresql-18-auto-failover_2.2-3.pgdg13+1_arm64.deb PGDG · 2.2 · 374.8KiB	PGDG 2.2 d13.aarch64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg13+1_arm64.deb PGDG · 2.2 · 372.8KiB postgresql-17-auto-failover_2.2-3.pgdg13+1_arm64.deb PGDG · 2.2 · 372.4KiB	PGDG 2.2 d13.aarch64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg13+1_arm64.deb PGDG · 2.2 · 365.6KiB postgresql-16-auto-failover_2.2-3.pgdg13+1_arm64.deb PGDG · 2.2 · 366.4KiB	PGDG 2.2 d13.aarch64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg13+1_arm64.deb PGDG · 2.2 · 366.0KiB postgresql-15-auto-failover_2.2-3.pgdg13+1_arm64.deb PGDG · 2.2 · 366.1KiB	PGDG 2.2 d13.aarch64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg13+1_arm64.deb PGDG · 2.2 · 360.6KiB postgresql-14-auto-failover_2.2-3.pgdg13+1_arm64.deb PGDG · 2.2 · 360.4KiB
u22.x86_64	PGDG 2.2 u22.x86_64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg22.04+1_amd64.deb PGDG · 2.2 · 378.2KiB postgresql-18-auto-failover_2.2-3.pgdg22.04+1_amd64.deb PGDG · 2.2 · 378.3KiB	PGDG 2.2 u22.x86_64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg22.04+1_amd64.deb PGDG · 2.2 · 393.5KiB postgresql-17-auto-failover_2.2-3.pgdg22.04+1_amd64.deb PGDG · 2.2 · 393.9KiB	PGDG 2.2 u22.x86_64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg22.04+1_amd64.deb PGDG · 2.2 · 387.6KiB postgresql-16-auto-failover_2.2-3.pgdg22.04+1_amd64.deb PGDG · 2.2 · 387.5KiB	PGDG 2.2 u22.x86_64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg22.04+1_amd64.deb PGDG · 2.2 · 391.5KiB postgresql-15-auto-failover_2.2-3.pgdg22.04+1_amd64.deb PGDG · 2.2 · 391.1KiB	PGDG 2.2 u22.x86_64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg22.04+1_amd64.deb PGDG · 2.2 · 387.0KiB postgresql-14-auto-failover_2.2-3.pgdg22.04+1_amd64.deb PGDG · 2.2 · 386.6KiB
u22.aarch64	PGDG 2.2 u22.aarch64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg22.04+1_arm64.deb PGDG · 2.2 · 374.2KiB postgresql-18-auto-failover_2.2-3.pgdg22.04+1_arm64.deb PGDG · 2.2 · 374.1KiB	PGDG 2.2 u22.aarch64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg22.04+1_arm64.deb PGDG · 2.2 · 389.0KiB postgresql-17-auto-failover_2.2-3.pgdg22.04+1_arm64.deb PGDG · 2.2 · 388.7KiB	PGDG 2.2 u22.aarch64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg22.04+1_arm64.deb PGDG · 2.2 · 383.5KiB postgresql-16-auto-failover_2.2-3.pgdg22.04+1_arm64.deb PGDG · 2.2 · 383.4KiB	PGDG 2.2 u22.aarch64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg22.04+1_arm64.deb PGDG · 2.2 · 387.7KiB postgresql-15-auto-failover_2.2-3.pgdg22.04+1_arm64.deb PGDG · 2.2 · 388.1KiB	PGDG 2.2 u22.aarch64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg22.04+1_arm64.deb PGDG · 2.2 · 383.0KiB postgresql-14-auto-failover_2.2-3.pgdg22.04+1_arm64.deb PGDG · 2.2 · 382.8KiB
u24.x86_64	PGDG 2.2 u24.x86_64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg24.04+1_amd64.deb PGDG · 2.2 · 369.3KiB postgresql-18-auto-failover_2.2-3.pgdg24.04+1_amd64.deb PGDG · 2.2 · 369.2KiB	PGDG 2.2 u24.x86_64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg24.04+1_amd64.deb PGDG · 2.2 · 364.6KiB postgresql-17-auto-failover_2.2-3.pgdg24.04+1_amd64.deb PGDG · 2.2 · 364.9KiB	PGDG 2.2 u24.x86_64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg24.04+1_amd64.deb PGDG · 2.2 · 358.6KiB postgresql-16-auto-failover_2.2-3.pgdg24.04+1_amd64.deb PGDG · 2.2 · 358.7KiB	PGDG 2.2 u24.x86_64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg24.04+1_amd64.deb PGDG · 2.2 · 360.3KiB postgresql-15-auto-failover_2.2-3.pgdg24.04+1_amd64.deb PGDG · 2.2 · 360.6KiB	PGDG 2.2 u24.x86_64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg24.04+1_amd64.deb PGDG · 2.2 · 355.0KiB postgresql-14-auto-failover_2.2-3.pgdg24.04+1_amd64.deb PGDG · 2.2 · 354.8KiB
u24.aarch64	PGDG 2.2 u24.aarch64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg24.04+1_arm64.deb PGDG · 2.2 · 364.7KiB postgresql-18-auto-failover_2.2-3.pgdg24.04+1_arm64.deb PGDG · 2.2 · 364.7KiB	PGDG 2.2 u24.aarch64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg24.04+1_arm64.deb PGDG · 2.2 · 362.2KiB postgresql-17-auto-failover_2.2-3.pgdg24.04+1_arm64.deb PGDG · 2.2 · 362.5KiB	PGDG 2.2 u24.aarch64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg24.04+1_arm64.deb PGDG · 2.2 · 356.2KiB postgresql-16-auto-failover_2.2-3.pgdg24.04+1_arm64.deb PGDG · 2.2 · 356.6KiB	PGDG 2.2 u24.aarch64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg24.04+1_arm64.deb PGDG · 2.2 · 357.6KiB postgresql-15-auto-failover_2.2-3.pgdg24.04+1_arm64.deb PGDG · 2.2 · 357.6KiB	PGDG 2.2 u24.aarch64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg24.04+1_arm64.deb PGDG · 2.2 · 351.0KiB postgresql-14-auto-failover_2.2-3.pgdg24.04+1_arm64.deb PGDG · 2.2 · 350.8KiB
u26.x86_64	PGDG 2.2 u26.x86_64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg26.04+1_amd64.deb PGDG · 2.2 · 368.4KiB postgresql-18-auto-failover_2.2-3.pgdg26.04+1_amd64.deb PGDG · 2.2 · 368.7KiB	PGDG 2.2 u26.x86_64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg26.04+1_amd64.deb PGDG · 2.2 · 366.4KiB postgresql-17-auto-failover_2.2-3.pgdg26.04+1_amd64.deb PGDG · 2.2 · 366.9KiB	PGDG 2.2 u26.x86_64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg26.04+1_amd64.deb PGDG · 2.2 · 360.4KiB postgresql-16-auto-failover_2.2-3.pgdg26.04+1_amd64.deb PGDG · 2.2 · 360.7KiB	PGDG 2.2 u26.x86_64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg26.04+1_amd64.deb PGDG · 2.2 · 362.6KiB postgresql-15-auto-failover_2.2-3.pgdg26.04+1_amd64.deb PGDG · 2.2 · 363.0KiB	PGDG 2.2 u26.x86_64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg26.04+1_amd64.deb PGDG · 2.2 · 357.2KiB postgresql-14-auto-failover_2.2-3.pgdg26.04+1_amd64.deb PGDG · 2.2 · 357.2KiB
u26.aarch64	PGDG 2.2 u26.aarch64.pg18 : postgresql-18-auto-failover postgresql-18-auto-failover_2.2-4.pgdg26.04+1_arm64.deb PGDG · 2.2 · 364.1KiB postgresql-18-auto-failover_2.2-3.pgdg26.04+1_arm64.deb PGDG · 2.2 · 364.4KiB	PGDG 2.2 u26.aarch64.pg17 : postgresql-17-auto-failover postgresql-17-auto-failover_2.2-4.pgdg26.04+1_arm64.deb PGDG · 2.2 · 361.5KiB postgresql-17-auto-failover_2.2-3.pgdg26.04+1_arm64.deb PGDG · 2.2 · 361.7KiB	PGDG 2.2 u26.aarch64.pg16 : postgresql-16-auto-failover postgresql-16-auto-failover_2.2-4.pgdg26.04+1_arm64.deb PGDG · 2.2 · 356.8KiB postgresql-16-auto-failover_2.2-3.pgdg26.04+1_arm64.deb PGDG · 2.2 · 357.7KiB	PGDG 2.2 u26.aarch64.pg15 : postgresql-15-auto-failover postgresql-15-auto-failover_2.2-4.pgdg26.04+1_arm64.deb PGDG · 2.2 · 357.5KiB postgresql-15-auto-failover_2.2-3.pgdg26.04+1_arm64.deb PGDG · 2.2 · 357.8KiB	PGDG 2.2 u26.aarch64.pg14 : postgresql-14-auto-failover postgresql-14-auto-failover_2.2-4.pgdg26.04+1_arm64.deb PGDG · 2.2 · 353.2KiB postgresql-14-auto-failover_2.2-3.pgdg26.04+1_arm64.deb PGDG · 2.2 · 353.5KiB

安装

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

BASH

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

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

安装

BASH

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

pig

BASH

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

dnf

BASH

dnf install -y pg_auto_failover_18       # PG 18
dnf install -y pg_auto_failover_17       # PG 17
dnf install -y pg_auto_failover_16       # PG 16
dnf install -y pg_auto_failover_15       # PG 15
dnf install -y pg_auto_failover_14       # PG 14

apt

BASH

apt install -y postgresql-18-auto-failover   # PG 18
apt install -y postgresql-17-auto-failover   # PG 17
apt install -y postgresql-16-auto-failover   # PG 16
apt install -y postgresql-15-auto-failover   # PG 15
apt install -y postgresql-14-auto-failover   # PG 14

预加载配置：

BASH

shared_preload_libraries = 'pgautofailover';

创建扩展：

SQL

CREATE EXTENSION pgautofailover CASCADE;  -- 依赖: btree_gist

用法

pgautofailover: PostgreSQL 自动故障转移

pg_auto_failover 是一个用于 PostgreSQL 自动故障转移的扩展和服务。它由一个监控节点（运行 pgautofailover 扩展）和每个数据节点上由 pg_autoctl CLI 管理的 keeper 进程组成。

架构

监控节点：安装了 pgautofailover 扩展的 PostgreSQL 实例，实现了用于故障转移决策的状态机
Keeper（pg_autoctl run）：运行在每个数据节点上，向监控节点报告健康状态并执行状态转换
支持 2 个以上节点的设置，默认使用同步复制
支持 Citus HA（v2.0 起）

关键 CLI 命令

BASH

# 创建监控节点
pg_autoctl create monitor --pgdata /path/to/monitor --pgport 5000

# 创建数据节点（自动分配为主节点或从节点）
pg_autoctl create postgres --pgdata /path/to/data --pgport 5001 --monitor postgres://monitor:5000/pg_auto_failover

# 运行 keeper（前台模式）
pg_autoctl run --pgdata /path/to/data

# 检查集群状态
pg_autoctl show state --pgdata /path/to/monitor

# 执行手动切换
pg_autoctl perform switchover --pgdata /path/to/monitor

# 执行手动故障转移
pg_autoctl perform failover --pgdata /path/to/monitor

故障转移行为

监控节点跟踪节点健康状态。当从节点不可用或其延迟过高时，会从主节点的 synchronous_standby_names 中移除。在从节点恢复健康之前，故障转移/切换操作会被阻止，以防止数据丢失。

文档

完整文档：pg-auto-failover.readthedocs.io

意见反馈

这个页面对您有帮助吗？

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

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