pgautofailover

pg_auto_failover

Overview

ID	Extension	Package	Version	Category	License	Language
5150	pgautofailover	pgautofailover	`2.2`	ADMIN	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--sLd--	No	Yes	Yes	Yes	no	no

Relationships
Requires	btree_gist
See Also	repmgr pg_failover_slots bgw_replstatus pgpool_adm pglogical pgactive pglogical_ticker

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PGDG	`2.2`	18 17 16 15 14	`pgautofailover`	`btree_gist`
RPM	PGDG	`2.2`	18 17 16 15 14	`pg_auto_failover_$v`	-
DEB	PGDG	`2.2`	18 17 16 15 14	`postgresql-$v-auto-failover`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
el8.aarch64	PIGSTY 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
el9.x86_64	PIGSTY 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
el9.aarch64	PIGSTY 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
el10.x86_64	PIGSTY 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
el10.aarch64	PIGSTY 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
d12.x86_64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
d12.aarch64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
d13.x86_64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
d13.aarch64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
u22.x86_64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
u22.aarch64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
u24.x86_64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
u24.aarch64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
u26.x86_64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2
u26.aarch64	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2	PGDG 2.2

Package	Version	OS	ORG	SIZE	File URL
`pg_auto_failover_18`	`2.2`	el8.x86_64	pigsty	837.3 KiB	pg_auto_failover_18-2.2-5PIGSTY.el8.x86_64.rpm
`pg_auto_failover_18`	`2.2`	el8.aarch64	pigsty	837.3 KiB	pg_auto_failover_18-2.2-5PIGSTY.el8.aarch64.rpm
`pg_auto_failover_18`	`2.2`	el9.x86_64	pigsty	789.9 KiB	pg_auto_failover_18-2.2-5PIGSTY.el9.x86_64.rpm
`pg_auto_failover_18`	`2.2`	el9.aarch64	pigsty	792.8 KiB	pg_auto_failover_18-2.2-5PIGSTY.el9.aarch64.rpm
`pg_auto_failover_18`	`2.2`	el10.x86_64	pigsty	791.4 KiB	pg_auto_failover_18-2.2-5PIGSTY.el10.x86_64.rpm
`pg_auto_failover_18`	`2.2`	el10.aarch64	pigsty	789.1 KiB	pg_auto_failover_18-2.2-5PIGSTY.el10.aarch64.rpm
`postgresql-18-auto-failover`	`2.2`	d12.x86_64	pgdg	378.2 KiB	postgresql-18-auto-failover_2.2-4.pgdg12+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	d12.x86_64	pgdg	377.7 KiB	postgresql-18-auto-failover_2.2-3.pgdg12+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	d12.aarch64	pgdg	373.7 KiB	postgresql-18-auto-failover_2.2-4.pgdg12+1_arm64.deb
`postgresql-18-auto-failover`	`2.2`	d12.aarch64	pgdg	373.6 KiB	postgresql-18-auto-failover_2.2-3.pgdg12+1_arm64.deb
`postgresql-18-auto-failover`	`2.2`	d13.x86_64	pgdg	379.7 KiB	postgresql-18-auto-failover_2.2-4.pgdg13+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	d13.x86_64	pgdg	379.1 KiB	postgresql-18-auto-failover_2.2-3.pgdg13+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	d13.aarch64	pgdg	374.8 KiB	postgresql-18-auto-failover_2.2-4.pgdg13+1_arm64.deb
`postgresql-18-auto-failover`	`2.2`	d13.aarch64	pgdg	374.8 KiB	postgresql-18-auto-failover_2.2-3.pgdg13+1_arm64.deb
`postgresql-18-auto-failover`	`2.2`	u22.x86_64	pgdg	378.2 KiB	postgresql-18-auto-failover_2.2-4.pgdg22.04+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	u22.x86_64	pgdg	378.3 KiB	postgresql-18-auto-failover_2.2-3.pgdg22.04+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	u22.aarch64	pgdg	374.2 KiB	postgresql-18-auto-failover_2.2-4.pgdg22.04+1_arm64.deb
`postgresql-18-auto-failover`	`2.2`	u22.aarch64	pgdg	374.1 KiB	postgresql-18-auto-failover_2.2-3.pgdg22.04+1_arm64.deb
`postgresql-18-auto-failover`	`2.2`	u24.x86_64	pgdg	369.3 KiB	postgresql-18-auto-failover_2.2-4.pgdg24.04+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	u24.x86_64	pgdg	369.2 KiB	postgresql-18-auto-failover_2.2-3.pgdg24.04+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	u24.aarch64	pgdg	364.7 KiB	postgresql-18-auto-failover_2.2-4.pgdg24.04+1_arm64.deb
`postgresql-18-auto-failover`	`2.2`	u24.aarch64	pgdg	364.7 KiB	postgresql-18-auto-failover_2.2-3.pgdg24.04+1_arm64.deb
`postgresql-18-auto-failover`	`2.2`	u26.x86_64	pgdg	368.4 KiB	postgresql-18-auto-failover_2.2-4.pgdg26.04+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	u26.x86_64	pgdg	368.7 KiB	postgresql-18-auto-failover_2.2-3.pgdg26.04+1_amd64.deb
`postgresql-18-auto-failover`	`2.2`	u26.aarch64	pgdg	364.1 KiB	postgresql-18-auto-failover_2.2-4.pgdg26.04+1_arm64.deb
`postgresql-18-auto-failover`	`2.2`	u26.aarch64	pgdg	364.4 KiB	postgresql-18-auto-failover_2.2-3.pgdg26.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_auto_failover_17`	`2.2`	el8.x86_64	pgdg	812.9 KiB	pg_auto_failover_17-2.2-1PGDG.rhel8.x86_64.rpm
`pg_auto_failover_17`	`2.2`	el8.aarch64	pgdg	809.9 KiB	pg_auto_failover_17-2.2-1PGDG.rhel8.aarch64.rpm
`pg_auto_failover_17`	`2.2`	el9.x86_64	pgdg	786.4 KiB	pg_auto_failover_17-2.2-4PGDG.rhel9.8.x86_64.rpm
`pg_auto_failover_17`	`2.2`	el9.x86_64	pgdg	786.3 KiB	pg_auto_failover_17-2.2-1PGDG.rhel9.x86_64.rpm
`pg_auto_failover_17`	`2.2`	el9.aarch64	pgdg	789.1 KiB	pg_auto_failover_17-2.2-4PGDG.rhel9.8.aarch64.rpm
`pg_auto_failover_17`	`2.2`	el9.aarch64	pgdg	789.2 KiB	pg_auto_failover_17-2.2-1PGDG.rhel9.aarch64.rpm
`pg_auto_failover_17`	`2.2`	el10.x86_64	pgdg	788.1 KiB	pg_auto_failover_17-2.2-4PGDG.rhel10.2.x86_64.rpm
`pg_auto_failover_17`	`2.2`	el10.x86_64	pgdg	788.0 KiB	pg_auto_failover_17-2.2-1PGDG.rhel10.x86_64.rpm
`pg_auto_failover_17`	`2.2`	el10.aarch64	pgdg	785.8 KiB	pg_auto_failover_17-2.2-4PGDG.rhel10.2.aarch64.rpm
`pg_auto_failover_17`	`2.2`	el10.aarch64	pgdg	785.7 KiB	pg_auto_failover_17-2.2-1PGDG.rhel10.aarch64.rpm
`postgresql-17-auto-failover`	`2.2`	d12.x86_64	pgdg	374.0 KiB	postgresql-17-auto-failover_2.2-4.pgdg12+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	d12.x86_64	pgdg	374.2 KiB	postgresql-17-auto-failover_2.2-3.pgdg12+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	d12.aarch64	pgdg	370.7 KiB	postgresql-17-auto-failover_2.2-4.pgdg12+1_arm64.deb
`postgresql-17-auto-failover`	`2.2`	d12.aarch64	pgdg	370.7 KiB	postgresql-17-auto-failover_2.2-3.pgdg12+1_arm64.deb
`postgresql-17-auto-failover`	`2.2`	d13.x86_64	pgdg	374.8 KiB	postgresql-17-auto-failover_2.2-4.pgdg13+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	d13.x86_64	pgdg	375.0 KiB	postgresql-17-auto-failover_2.2-3.pgdg13+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	d13.aarch64	pgdg	372.8 KiB	postgresql-17-auto-failover_2.2-4.pgdg13+1_arm64.deb
`postgresql-17-auto-failover`	`2.2`	d13.aarch64	pgdg	372.4 KiB	postgresql-17-auto-failover_2.2-3.pgdg13+1_arm64.deb
`postgresql-17-auto-failover`	`2.2`	u22.x86_64	pgdg	393.5 KiB	postgresql-17-auto-failover_2.2-4.pgdg22.04+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	u22.x86_64	pgdg	393.9 KiB	postgresql-17-auto-failover_2.2-3.pgdg22.04+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	u22.aarch64	pgdg	389.0 KiB	postgresql-17-auto-failover_2.2-4.pgdg22.04+1_arm64.deb
`postgresql-17-auto-failover`	`2.2`	u22.aarch64	pgdg	388.7 KiB	postgresql-17-auto-failover_2.2-3.pgdg22.04+1_arm64.deb
`postgresql-17-auto-failover`	`2.2`	u24.x86_64	pgdg	364.6 KiB	postgresql-17-auto-failover_2.2-4.pgdg24.04+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	u24.x86_64	pgdg	364.9 KiB	postgresql-17-auto-failover_2.2-3.pgdg24.04+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	u24.aarch64	pgdg	362.2 KiB	postgresql-17-auto-failover_2.2-4.pgdg24.04+1_arm64.deb
`postgresql-17-auto-failover`	`2.2`	u24.aarch64	pgdg	362.5 KiB	postgresql-17-auto-failover_2.2-3.pgdg24.04+1_arm64.deb
`postgresql-17-auto-failover`	`2.2`	u26.x86_64	pgdg	366.4 KiB	postgresql-17-auto-failover_2.2-4.pgdg26.04+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	u26.x86_64	pgdg	366.9 KiB	postgresql-17-auto-failover_2.2-3.pgdg26.04+1_amd64.deb
`postgresql-17-auto-failover`	`2.2`	u26.aarch64	pgdg	361.5 KiB	postgresql-17-auto-failover_2.2-4.pgdg26.04+1_arm64.deb
`postgresql-17-auto-failover`	`2.2`	u26.aarch64	pgdg	361.7 KiB	postgresql-17-auto-failover_2.2-3.pgdg26.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_auto_failover_16`	`2.2`	el8.x86_64	pgdg	812.5 KiB	pg_auto_failover_16-2.2-1PGDG.rhel8.x86_64.rpm
`pg_auto_failover_16`	`2.1`	el8.x86_64	pgdg	844.0 KiB	pg_auto_failover_16-2.1-1PGDG.rhel8.x86_64.rpm
`pg_auto_failover_16`	`2.2`	el8.aarch64	pgdg	809.4 KiB	pg_auto_failover_16-2.2-1PGDG.rhel8.aarch64.rpm
`pg_auto_failover_16`	`2.1`	el8.aarch64	pgdg	843.8 KiB	pg_auto_failover_16-2.1-1PGDG.rhel8.aarch64.rpm
`pg_auto_failover_16`	`2.2`	el9.x86_64	pgdg	786.4 KiB	pg_auto_failover_16-2.2-4PGDG.rhel9.8.x86_64.rpm
`pg_auto_failover_16`	`2.2`	el9.x86_64	pgdg	786.3 KiB	pg_auto_failover_16-2.2-1PGDG.rhel9.x86_64.rpm
`pg_auto_failover_16`	`2.1`	el9.x86_64	pgdg	807.5 KiB	pg_auto_failover_16-2.1-1PGDG.rhel9.x86_64.rpm
`pg_auto_failover_16`	`2.2`	el9.aarch64	pgdg	789.2 KiB	pg_auto_failover_16-2.2-4PGDG.rhel9.8.aarch64.rpm
`pg_auto_failover_16`	`2.2`	el9.aarch64	pgdg	789.1 KiB	pg_auto_failover_16-2.2-1PGDG.rhel9.aarch64.rpm
`pg_auto_failover_16`	`2.1`	el9.aarch64	pgdg	817.4 KiB	pg_auto_failover_16-2.1-1PGDG.rhel9.aarch64.rpm
`pg_auto_failover_16`	`2.2`	el10.x86_64	pgdg	787.9 KiB	pg_auto_failover_16-2.2-4PGDG.rhel10.2.x86_64.rpm
`pg_auto_failover_16`	`2.2`	el10.x86_64	pgdg	788.1 KiB	pg_auto_failover_16-2.2-1PGDG.rhel10.x86_64.rpm
`pg_auto_failover_16`	`2.2`	el10.aarch64	pgdg	785.8 KiB	pg_auto_failover_16-2.2-4PGDG.rhel10.2.aarch64.rpm
`pg_auto_failover_16`	`2.2`	el10.aarch64	pgdg	785.7 KiB	pg_auto_failover_16-2.2-1PGDG.rhel10.aarch64.rpm
`postgresql-16-auto-failover`	`2.2`	d12.x86_64	pgdg	368.4 KiB	postgresql-16-auto-failover_2.2-4.pgdg12+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	d12.x86_64	pgdg	368.8 KiB	postgresql-16-auto-failover_2.2-3.pgdg12+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	d12.aarch64	pgdg	364.8 KiB	postgresql-16-auto-failover_2.2-4.pgdg12+1_arm64.deb
`postgresql-16-auto-failover`	`2.2`	d12.aarch64	pgdg	365.9 KiB	postgresql-16-auto-failover_2.2-3.pgdg12+1_arm64.deb
`postgresql-16-auto-failover`	`2.2`	d13.x86_64	pgdg	369.6 KiB	postgresql-16-auto-failover_2.2-4.pgdg13+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	d13.x86_64	pgdg	369.8 KiB	postgresql-16-auto-failover_2.2-3.pgdg13+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	d13.aarch64	pgdg	365.6 KiB	postgresql-16-auto-failover_2.2-4.pgdg13+1_arm64.deb
`postgresql-16-auto-failover`	`2.2`	d13.aarch64	pgdg	366.4 KiB	postgresql-16-auto-failover_2.2-3.pgdg13+1_arm64.deb
`postgresql-16-auto-failover`	`2.2`	u22.x86_64	pgdg	387.6 KiB	postgresql-16-auto-failover_2.2-4.pgdg22.04+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	u22.x86_64	pgdg	387.5 KiB	postgresql-16-auto-failover_2.2-3.pgdg22.04+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	u22.aarch64	pgdg	383.5 KiB	postgresql-16-auto-failover_2.2-4.pgdg22.04+1_arm64.deb
`postgresql-16-auto-failover`	`2.2`	u22.aarch64	pgdg	383.4 KiB	postgresql-16-auto-failover_2.2-3.pgdg22.04+1_arm64.deb
`postgresql-16-auto-failover`	`2.2`	u24.x86_64	pgdg	358.6 KiB	postgresql-16-auto-failover_2.2-4.pgdg24.04+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	u24.x86_64	pgdg	358.7 KiB	postgresql-16-auto-failover_2.2-3.pgdg24.04+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	u24.aarch64	pgdg	356.2 KiB	postgresql-16-auto-failover_2.2-4.pgdg24.04+1_arm64.deb
`postgresql-16-auto-failover`	`2.2`	u24.aarch64	pgdg	356.6 KiB	postgresql-16-auto-failover_2.2-3.pgdg24.04+1_arm64.deb
`postgresql-16-auto-failover`	`2.2`	u26.x86_64	pgdg	360.4 KiB	postgresql-16-auto-failover_2.2-4.pgdg26.04+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	u26.x86_64	pgdg	360.7 KiB	postgresql-16-auto-failover_2.2-3.pgdg26.04+1_amd64.deb
`postgresql-16-auto-failover`	`2.2`	u26.aarch64	pgdg	356.8 KiB	postgresql-16-auto-failover_2.2-4.pgdg26.04+1_arm64.deb
`postgresql-16-auto-failover`	`2.2`	u26.aarch64	pgdg	357.7 KiB	postgresql-16-auto-failover_2.2-3.pgdg26.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_auto_failover_15`	`2.2`	el8.x86_64	pgdg	812.6 KiB	pg_auto_failover_15-2.2-1PGDG.rhel8.x86_64.rpm
`pg_auto_failover_15`	`2.1`	el8.x86_64	pgdg	843.6 KiB	pg_auto_failover_15-2.1-1PGDG.rhel8.x86_64.rpm
`pg_auto_failover_15`	`2.0`	el8.x86_64	pgdg	842.5 KiB	pg_auto_failover_15-2.0-1.rhel8.x86_64.rpm
`pg_auto_failover_15`	`2.2`	el8.aarch64	pgdg	809.3 KiB	pg_auto_failover_15-2.2-1PGDG.rhel8.aarch64.rpm
`pg_auto_failover_15`	`2.1`	el8.aarch64	pgdg	843.0 KiB	pg_auto_failover_15-2.1-1PGDG.rhel8.aarch64.rpm
`pg_auto_failover_15`	`2.0`	el8.aarch64	pgdg	841.6 KiB	pg_auto_failover_15-2.0-1.rhel8.aarch64.rpm
`pg_auto_failover_15`	`2.2`	el9.x86_64	pgdg	789.5 KiB	pg_auto_failover_15-2.2-4PGDG.rhel9.8.x86_64.rpm
`pg_auto_failover_15`	`2.2`	el9.x86_64	pgdg	789.5 KiB	pg_auto_failover_15-2.2-1PGDG.rhel9.x86_64.rpm
`pg_auto_failover_15`	`2.1`	el9.x86_64	pgdg	811.6 KiB	pg_auto_failover_15-2.1-1PGDG.rhel9.x86_64.rpm
`pg_auto_failover_15`	`2.0`	el9.x86_64	pgdg	812.1 KiB	pg_auto_failover_15-2.0-1.rhel9.x86_64.rpm
`pg_auto_failover_15`	`2.2`	el9.aarch64	pgdg	792.2 KiB	pg_auto_failover_15-2.2-4PGDG.rhel9.8.aarch64.rpm
`pg_auto_failover_15`	`2.2`	el9.aarch64	pgdg	792.9 KiB	pg_auto_failover_15-2.2-1PGDG.rhel9.aarch64.rpm
`pg_auto_failover_15`	`2.1`	el9.aarch64	pgdg	820.9 KiB	pg_auto_failover_15-2.1-1PGDG.rhel9.aarch64.rpm
`pg_auto_failover_15`	`2.0`	el9.aarch64	pgdg	821.5 KiB	pg_auto_failover_15-2.0-1.rhel9.aarch64.rpm
`pg_auto_failover_15`	`2.2`	el10.x86_64	pgdg	791.6 KiB	pg_auto_failover_15-2.2-4PGDG.rhel10.2.x86_64.rpm
`pg_auto_failover_15`	`2.2`	el10.x86_64	pgdg	791.7 KiB	pg_auto_failover_15-2.2-1PGDG.rhel10.x86_64.rpm
`pg_auto_failover_15`	`2.2`	el10.aarch64	pgdg	789.0 KiB	pg_auto_failover_15-2.2-4PGDG.rhel10.2.aarch64.rpm
`pg_auto_failover_15`	`2.2`	el10.aarch64	pgdg	788.8 KiB	pg_auto_failover_15-2.2-1PGDG.rhel10.aarch64.rpm
`postgresql-15-auto-failover`	`2.2`	d12.x86_64	pgdg	368.6 KiB	postgresql-15-auto-failover_2.2-4.pgdg12+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	d12.x86_64	pgdg	368.4 KiB	postgresql-15-auto-failover_2.2-3.pgdg12+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	d12.aarch64	pgdg	365.3 KiB	postgresql-15-auto-failover_2.2-4.pgdg12+1_arm64.deb
`postgresql-15-auto-failover`	`2.2`	d12.aarch64	pgdg	365.9 KiB	postgresql-15-auto-failover_2.2-3.pgdg12+1_arm64.deb
`postgresql-15-auto-failover`	`2.2`	d13.x86_64	pgdg	369.7 KiB	postgresql-15-auto-failover_2.2-4.pgdg13+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	d13.x86_64	pgdg	370.1 KiB	postgresql-15-auto-failover_2.2-3.pgdg13+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	d13.aarch64	pgdg	366.0 KiB	postgresql-15-auto-failover_2.2-4.pgdg13+1_arm64.deb
`postgresql-15-auto-failover`	`2.2`	d13.aarch64	pgdg	366.1 KiB	postgresql-15-auto-failover_2.2-3.pgdg13+1_arm64.deb
`postgresql-15-auto-failover`	`2.2`	u22.x86_64	pgdg	391.5 KiB	postgresql-15-auto-failover_2.2-4.pgdg22.04+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	u22.x86_64	pgdg	391.1 KiB	postgresql-15-auto-failover_2.2-3.pgdg22.04+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	u22.aarch64	pgdg	387.7 KiB	postgresql-15-auto-failover_2.2-4.pgdg22.04+1_arm64.deb
`postgresql-15-auto-failover`	`2.2`	u22.aarch64	pgdg	388.1 KiB	postgresql-15-auto-failover_2.2-3.pgdg22.04+1_arm64.deb
`postgresql-15-auto-failover`	`2.2`	u24.x86_64	pgdg	360.3 KiB	postgresql-15-auto-failover_2.2-4.pgdg24.04+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	u24.x86_64	pgdg	360.6 KiB	postgresql-15-auto-failover_2.2-3.pgdg24.04+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	u24.aarch64	pgdg	357.6 KiB	postgresql-15-auto-failover_2.2-4.pgdg24.04+1_arm64.deb
`postgresql-15-auto-failover`	`2.2`	u24.aarch64	pgdg	357.6 KiB	postgresql-15-auto-failover_2.2-3.pgdg24.04+1_arm64.deb
`postgresql-15-auto-failover`	`2.2`	u26.x86_64	pgdg	362.6 KiB	postgresql-15-auto-failover_2.2-4.pgdg26.04+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	u26.x86_64	pgdg	363.0 KiB	postgresql-15-auto-failover_2.2-3.pgdg26.04+1_amd64.deb
`postgresql-15-auto-failover`	`2.2`	u26.aarch64	pgdg	357.5 KiB	postgresql-15-auto-failover_2.2-4.pgdg26.04+1_arm64.deb
`postgresql-15-auto-failover`	`2.2`	u26.aarch64	pgdg	357.8 KiB	postgresql-15-auto-failover_2.2-3.pgdg26.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_auto_failover_14`	`2.2`	el8.x86_64	pgdg	810.9 KiB	pg_auto_failover_14-2.2-1PGDG.rhel8.x86_64.rpm
`pg_auto_failover_14`	`2.1`	el8.x86_64	pgdg	841.9 KiB	pg_auto_failover_14-2.1-1PGDG.rhel8.x86_64.rpm
`pg_auto_failover_14`	`2.0`	el8.x86_64	pgdg	840.6 KiB	pg_auto_failover_14-2.0-1.rhel8.x86_64.rpm
`pg_auto_failover_14`	`1.6.4`	el8.x86_64	pgdg	994.9 KiB	pg_auto_failover_14-1.6.4-1.rhel8.x86_64.rpm
`pg_auto_failover_14`	`1.6.2`	el8.x86_64	pgdg	929.2 KiB	pg_auto_failover_14-1.6.2-1.rhel8.x86_64.rpm
`pg_auto_failover_14`	`2.2`	el8.aarch64	pgdg	808.0 KiB	pg_auto_failover_14-2.2-1PGDG.rhel8.aarch64.rpm
`pg_auto_failover_14`	`2.1`	el8.aarch64	pgdg	841.4 KiB	pg_auto_failover_14-2.1-1PGDG.rhel8.aarch64.rpm
`pg_auto_failover_14`	`2.0`	el8.aarch64	pgdg	840.1 KiB	pg_auto_failover_14-2.0-1.rhel8.aarch64.rpm
`pg_auto_failover_14`	`2.2`	el9.x86_64	pgdg	789.0 KiB	pg_auto_failover_14-2.2-4PGDG.rhel9.8.x86_64.rpm
`pg_auto_failover_14`	`2.2`	el9.x86_64	pgdg	789.0 KiB	pg_auto_failover_14-2.2-1PGDG.rhel9.x86_64.rpm
`pg_auto_failover_14`	`2.1`	el9.x86_64	pgdg	811.2 KiB	pg_auto_failover_14-2.1-1PGDG.rhel9.x86_64.rpm
`pg_auto_failover_14`	`2.0`	el9.x86_64	pgdg	811.7 KiB	pg_auto_failover_14-2.0-1.rhel9.x86_64.rpm
`pg_auto_failover_14`	`1.6.4`	el9.x86_64	pgdg	966.2 KiB	pg_auto_failover_14-1.6.4-1.rhel9.x86_64.rpm
`pg_auto_failover_14`	`2.2`	el9.aarch64	pgdg	791.7 KiB	pg_auto_failover_14-2.2-4PGDG.rhel9.8.aarch64.rpm
`pg_auto_failover_14`	`2.2`	el9.aarch64	pgdg	792.5 KiB	pg_auto_failover_14-2.2-1PGDG.rhel9.aarch64.rpm
`pg_auto_failover_14`	`2.1`	el9.aarch64	pgdg	820.6 KiB	pg_auto_failover_14-2.1-1PGDG.rhel9.aarch64.rpm
`pg_auto_failover_14`	`2.0`	el9.aarch64	pgdg	821.0 KiB	pg_auto_failover_14-2.0-1.rhel9.aarch64.rpm
`pg_auto_failover_14`	`2.2`	el10.x86_64	pgdg	792.1 KiB	pg_auto_failover_14-2.2-4PGDG.rhel10.2.x86_64.rpm
`pg_auto_failover_14`	`2.2`	el10.x86_64	pgdg	792.2 KiB	pg_auto_failover_14-2.2-1PGDG.rhel10.x86_64.rpm
`pg_auto_failover_14`	`2.2`	el10.aarch64	pgdg	789.8 KiB	pg_auto_failover_14-2.2-4PGDG.rhel10.2.aarch64.rpm
`pg_auto_failover_14`	`2.2`	el10.aarch64	pgdg	789.6 KiB	pg_auto_failover_14-2.2-1PGDG.rhel10.aarch64.rpm
`postgresql-14-auto-failover`	`2.2`	d12.x86_64	pgdg	362.6 KiB	postgresql-14-auto-failover_2.2-4.pgdg12+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	d12.x86_64	pgdg	362.7 KiB	postgresql-14-auto-failover_2.2-3.pgdg12+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	d12.aarch64	pgdg	358.9 KiB	postgresql-14-auto-failover_2.2-4.pgdg12+1_arm64.deb
`postgresql-14-auto-failover`	`2.2`	d12.aarch64	pgdg	359.4 KiB	postgresql-14-auto-failover_2.2-3.pgdg12+1_arm64.deb
`postgresql-14-auto-failover`	`2.2`	d13.x86_64	pgdg	364.3 KiB	postgresql-14-auto-failover_2.2-4.pgdg13+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	d13.x86_64	pgdg	364.0 KiB	postgresql-14-auto-failover_2.2-3.pgdg13+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	d13.aarch64	pgdg	360.6 KiB	postgresql-14-auto-failover_2.2-4.pgdg13+1_arm64.deb
`postgresql-14-auto-failover`	`2.2`	d13.aarch64	pgdg	360.4 KiB	postgresql-14-auto-failover_2.2-3.pgdg13+1_arm64.deb
`postgresql-14-auto-failover`	`2.2`	u22.x86_64	pgdg	387.0 KiB	postgresql-14-auto-failover_2.2-4.pgdg22.04+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	u22.x86_64	pgdg	386.6 KiB	postgresql-14-auto-failover_2.2-3.pgdg22.04+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	u22.aarch64	pgdg	383.0 KiB	postgresql-14-auto-failover_2.2-4.pgdg22.04+1_arm64.deb
`postgresql-14-auto-failover`	`2.2`	u22.aarch64	pgdg	382.8 KiB	postgresql-14-auto-failover_2.2-3.pgdg22.04+1_arm64.deb
`postgresql-14-auto-failover`	`2.2`	u24.x86_64	pgdg	355.0 KiB	postgresql-14-auto-failover_2.2-4.pgdg24.04+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	u24.x86_64	pgdg	354.8 KiB	postgresql-14-auto-failover_2.2-3.pgdg24.04+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	u24.aarch64	pgdg	351.0 KiB	postgresql-14-auto-failover_2.2-4.pgdg24.04+1_arm64.deb
`postgresql-14-auto-failover`	`2.2`	u24.aarch64	pgdg	350.8 KiB	postgresql-14-auto-failover_2.2-3.pgdg24.04+1_arm64.deb
`postgresql-14-auto-failover`	`2.2`	u26.x86_64	pgdg	357.2 KiB	postgresql-14-auto-failover_2.2-4.pgdg26.04+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	u26.x86_64	pgdg	357.2 KiB	postgresql-14-auto-failover_2.2-3.pgdg26.04+1_amd64.deb
`postgresql-14-auto-failover`	`2.2`	u26.aarch64	pgdg	353.2 KiB	postgresql-14-auto-failover_2.2-4.pgdg26.04+1_arm64.deb
`postgresql-14-auto-failover`	`2.2`	u26.aarch64	pgdg	353.5 KiB	postgresql-14-auto-failover_2.2-3.pgdg26.04+1_arm64.deb

Source

Repository

github.com/hapostgres/pg_auto_failover

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install pgautofailover;		# install via package name, for the active PG version

pig install pgautofailover -v 18;   # install for PG 18
pig install pgautofailover -v 17;   # install for PG 17
pig install pgautofailover -v 16;   # install for PG 16
pig install pgautofailover -v 15;   # install for PG 15
pig install pgautofailover -v 14;   # install for PG 14

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pgautofailover';

Create this extension with:

CREATE EXTENSION pgautofailover CASCADE; -- requires btree_gist

Usage

pgautofailover: pg_auto_failover

pg_auto_failover is an extension and service for automated PostgreSQL failover. It consists of a monitor node (running the pgautofailover extension), and keeper processes on each data node managed by the pg_autoctl CLI.

Architecture

Monitor: a PostgreSQL instance with the pgautofailover extension that implements a state machine for failover decisions
Keeper (pg_autoctl run): runs on each data node, reports health to the monitor and executes state transitions
Supports 2+ node setups with synchronous replication by default
Supports Citus HA (since v2.0)

Key CLI Commands

# Create the monitor
pg_autoctl create monitor --pgdata /path/to/monitor --pgport 5000

# Create a data node (primary or secondary auto-assigned)
pg_autoctl create postgres --pgdata /path/to/data --pgport 5001 --monitor postgres://monitor:5000/pg_auto_failover

# Run the keeper (foreground)
pg_autoctl run --pgdata /path/to/data

# Check cluster state
pg_autoctl show state --pgdata /path/to/monitor

# Perform a manual switchover
pg_autoctl perform switchover --pgdata /path/to/monitor

# Perform a manual failover
pg_autoctl perform failover --pgdata /path/to/monitor

Failover Behavior

The monitor tracks node health. When a secondary becomes unavailable or its lag is too high, it is removed from synchronous_standby_names on the primary. Failover/switchover operations are blocked until the secondary is healthy again, preventing data loss.

Documentation

Full documentation: pg-auto-failover.readthedocs.io