Extensions
pgautofailover

pgautofailover

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
pglogical
pglogical_origin
pg_failover_slots
pgpool_recovery
repmgr
pg_checksums
pgpool_adm
bgw_replstatus

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
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el8.aarch64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el9.x86_64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el9.aarch64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el10.x86_64
MISS
PGDG 2.2
PGDG 2.2
PGDG 2.2
PGDG 2.2
el10.aarch64
MISS
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
Package Version OS ORG SIZE File URL
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.6 KiB postgresql-18-auto-failover_2.2-3.pgdg12+1_arm64.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-3.pgdg13+1_arm64.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.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.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-3.pgdg24.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.3 KiB pg_auto_failover_17-2.2-1PGDG.rhel9.x86_64.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.0 KiB pg_auto_failover_17-2.2-1PGDG.rhel10.x86_64.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.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-3.pgdg12+1_arm64.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.4 KiB postgresql-17-auto-failover_2.2-3.pgdg13+1_arm64.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 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.9 KiB postgresql-17-auto-failover_2.2-3.pgdg24.04+1_amd64.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
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.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.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 788.1 KiB pg_auto_failover_16-2.2-1PGDG.rhel10.x86_64.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.8 KiB postgresql-16-auto-failover_2.2-3.pgdg12+1_amd64.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.8 KiB postgresql-16-auto-failover_2.2-3.pgdg13+1_amd64.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.5 KiB postgresql-16-auto-failover_2.2-3.pgdg22.04+1_amd64.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.7 KiB postgresql-16-auto-failover_2.2-3.pgdg24.04+1_amd64.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
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-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.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.7 KiB pg_auto_failover_15-2.2-1PGDG.rhel10.x86_64.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.4 KiB postgresql-15-auto-failover_2.2-3.pgdg12+1_amd64.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 370.1 KiB postgresql-15-auto-failover_2.2-3.pgdg13+1_amd64.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.1 KiB postgresql-15-auto-failover_2.2-3.pgdg22.04+1_amd64.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.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-3.pgdg24.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-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 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.2 KiB pg_auto_failover_14-2.2-1PGDG.rhel10.x86_64.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.7 KiB postgresql-14-auto-failover_2.2-3.pgdg12+1_amd64.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.0 KiB postgresql-14-auto-failover_2.2-3.pgdg13+1_amd64.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 386.6 KiB postgresql-14-auto-failover_2.2-3.pgdg22.04+1_amd64.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 354.8 KiB postgresql-14-auto-failover_2.2-3.pgdg24.04+1_amd64.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

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
Last updated on
pg_permissionspg_catcheck